surabhi.ahuja wrote:
patName := trim($1);
select trim(trailing `^` from patName) INTO patName;
trim(patName);
I think this line should contain an assignment.
--
Alban Hertroys
---(end of broadcast)---
TIP 9: In versions be
atName;
> 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@postgr
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'DECLAREpatName
text;BEGIN
patName := tr
"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');
am 09.02.2006, um 11:54:43 +0530 mailte surabhi.ahuja folgendes:
> Hi
> hi i have varchar type fiels in a table.
>
> 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 g
Hi
hi i have varchar type fiels in a
table.
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
how should i do this.
thanks,
regards
Surabhi
