You need to use two single quotes around ^ (like ''^'') or use the dollar quoting approach. http://www.postgresql.org/docs/8.1/static/plpgsql-development-tips.html On 2/10/06, surabhi.ahuja <surabhi.ahuja@xxxxxxxxxxx> wrote: > > > 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@xxxxxxxxxxxxx] > Sent: Thu 2/9/2006 12:49 PM > To: surabhi.ahuja > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] r trim of characters other than space > > > > > *********************** > Your mail has been scanned by iiitb VirusWall. > ***********-*********** > > > "surabhi.ahuja" <surabhi.ahuja@xxxxxxxxxxx> 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 > > >
