Re: r trim of characters other than space

but how should i do it within a stored procedure
something like:

CREATE OR REPLACE FUNCTION insert(varchar(65),varchar(65),date,varchar(256)) RETURNS retval AS'
DECLARE
patName text;
BEGIN

patName := trim($1);
select trim(trailing `^` from patName) INTO patName;
trim(patName);

this seems to be giving syntax error

thanks,
regards
Surabhi

________________________________

From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thu 2/9/2006 12:49 PM
To: surabhi.ahuja
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] r trim of characters other than space

***********************
Your mail has been scanned by iiitb VirusWall.
***********-***********

"surabhi.ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> 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