Re:BUG #17407: trim trims more than expected

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: PG Bug reporting form <noreply(at)postgresql(dot)org>
Cc: unmesh(dot)joshi126(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re:BUG #17407: trim trims more than expected
Date: 2022-02-16 11:03:41
Message-ID: 2390361645009421@iva6-ab1cb434301d.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pantelis Theodosiou 2022-02-16 12:02:12 Re: BUG #17408: Duplicate aliases silently fail
Previous Message PG Bug reporting form 2022-02-16 10:36:31 BUG #17408: Duplicate aliases silently fail