Re: [GENERAL] r trim of characters other than space

[surabhi.ahuja]

Title: Re: [GENERAL] 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:[EMAIL PROTECTED]
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" <[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