Removing spaces

From: Dave Smith <dave(dot)smith(at)candata(dot)com>
To: PostgreSQL-General-List "(E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Removing spaces
Date: 2003-02-19 17:07:54
Message-ID: 1045674474.12427.22.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 Mark Cave-Ayland 2003-02-19 17:10:40 Re: 7.3.1 takes long time to vacuum table?
Previous Message Greg Copeland 2003-02-19 17:00:58 Re: Table Partitioning in Postgres: