trimming a column

From: "Michael P(dot) Soulier" <michael_soulier(at)mitel(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: trimming a column
Date: 2012-05-04 01:01:42
Message-ID: 20120504010141.GP5230@mitel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I need to trim whitespace off of a whole column and replace the existing
values with the trimmed ones.

This isn't working

update mytable set id = trim(id);

I'm not sure of the correct syntax. Help appreciated.

Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Williamson 2012-05-04 01:55:02 Re: trimming a column
Previous Message EllyR 2012-05-04 00:20:24 Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z)