Home > mailing lists

r trim of characters other than space - Mailing list pgsql-general

From	surabhi.ahuja
Subject	r trim of characters other than space
Date	February 9, 2006 05:21:28
Msg-id	967CFC4343BF2A4DAFACD026D33DC85118ECBC@jal.iiitb.ac.in Whole thread Raw
Responses	Re: r trim of characters other than space ("A. Kretschmer" <andreas.kretschmer@schollglas.com>) Re: r trim of characters other than space (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

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

From: Tom Lane
Date: 09 February 2006, 05:19:42
Subject: Re: Request to have VACUUM ignore cost based limits

From: "A. Kretschmer"
Date: 09 February 2006, 05:35:55
Subject: Re: r trim of characters other than space