Horton

Re:BUG #17407: trim trims more than expected

Sergei Kornilov <sk@zsrv.org>

View thread
From: Sergei Kornilov <sk@zsrv.org>
To: PG Bug reporting form <noreply@postgresql.org>
Cc: unmesh.joshi126@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2022-02-16T11:03:41Z
Lists: pgsql-bugs 
Hello
But why don't you expect such a result?

The letter a was definitely mentioned in the list of characters to trim.

select trim('nextval' from 'auth_table_id_seq');
      btrim       
------------------
 uth_table_id_seq

Is expected result. Probably you need some other string manipulation function. 

regards, Sergei