Emi Lu <[EMAIL PROTECTED]> writes: > select trim(both '<BR/>' from '<BR/>ROI Engineering Inc.'); > btrim > --------------------- > OI Engineering Inc. > (1 row)
> "R" is missing? How? The first argument of trim is a set, not a sequence --- it means trim any characters belonging to this set. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql