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@sss.pgh.pa.us]
Sent: Thu 2/9/2006 12:49 PM
To: surabhi.ahuja
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] r trim of characters other than space
***********************
Your mail has been scanned by iiitb VirusWall.
***********-***********
"surabhi.ahuja" <surabhi.ahuja@iiitb.ac.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