Re: removing leading and trailing blanks from every row in a table - Mailing list pgsql-novice

From Jasen Betts
Subject Re: removing leading and trailing blanks from every row in a table
Date
Msg-id glgcbd$4t1$10@reversiblemaps.ath.cx
Whole thread Raw
In response to removing leading and trailing blanks from every row in a table  ("Wm.A.Stafford" <stafford@marine.rutgers.edu>)
List pgsql-novice
On 2009-01-21, Wm.A.Stafford <stafford@marine.rutgers.edu> wrote:
> I need a procedure to remove leading and trailing blanks from column of
> every row in a table.  I would like to pass the table name as a
> parameter and have the procedure do the rest.  Does something like this
> already exist?  Is it even possible?

the sql to do this is

UPDATE tablename SET columnname=TRIM( columnname );

Do you really need a function?


pgsql-novice by date:

Previous
From: Daniel Staal
Date:
Subject: Re: SQL Question: Averages of intervals.
Next
From: Jasen Betts
Date:
Subject: Re: SQL Question: Averages of intervals.