Removing spaces

From: Dave Smith <dave(dot)smith(at)candata(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Removing spaces
Date: 2003-02-19 18:19:32
Message-ID: 1045678772.12427.25.camel@playpen
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a field of type text that has a value like

'hello \nworld \n'

I would like to remove the trailing blanks between the last character
and the newline. I would like to use replace with a regx like
/[ ]+\n/\n/ but it does not seem to work.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2003-02-19 18:26:07 Re: Removing spaces
Previous Message Greg Stark 2003-02-19 17:55:30 Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...