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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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