On Fri, 25 Apr 2008, Emi Lu wrote: > Hi, > > Isn't this a bug about trim both. > > select trim(both '<BR/>' from '<BR/>ROI Engineering Inc.'); > btrim > --------------------- > OI Engineering Inc. > (1 row) > > > "R" is missing? How?
Trim doesn't do what you think it does. The '<BR/>' in the above is not a string to remove it is a list of characters to remove. Thus, the R is removed as it matches a character given. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql