Skip site navigation (1) Skip section navigation (2)

removing leading and trailing blanks from every row in a table

From: "Wm(dot)A(dot)Stafford" <stafford(at)marine(dot)rutgers(dot)edu>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: removing leading and trailing blanks from every row in a table
Date: 2009-01-21 18:19:27
Message-ID: 4977672F.6080103@marine.rutgers.edu (view raw or flat)
Thread:
Lists: pgsql-novice
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?

Thanks,
-=beeky

Responses

pgsql-novice by date

Next:From: Christopher BrowneDate: 2009-01-21 19:31:30
Subject: Re: removing leading and trailing blanks from every row in a table
Previous:From: Nico CallewaertDate: 2009-01-21 15:40:52
Subject: Newbie question PostgreSQL / Postgres Plus / Tuning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group