"surabhi.ahuja" <[EMAIL PROTECTED]> writes: > i want to make the following check, > if it is having carets in the end, then those carets be removed. > so if i get a string like abc def^^^^ > i should be able to get abc def
Per SQL spec:
regression=# select trim(trailing '^' from 'abc def^^^^');
rtrim
---------
abc def
(1 row)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
