r trim of characters other than space

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: r trim of characters other than space
Date: 2006-02-09 06:24:43
Message-ID: 967CFC4343BF2A4DAFACD026D33DC85118ECBC@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2006-02-09 06:35:51 Re: r trim of characters other than space
Previous Message Tom Lane 2006-02-09 06:19:39 Re: Request to have VACUUM ignore cost based limits