On Oct 27, 2006, at 12:39 PM, J B wrote:
Guys,
I have a table that has various fields that have whitespace in the
values. I'd like to roll through and strip the left and right
whitespace out of all fields that contain strings.
Is there any easy way to do this?
UPDATE foo SET bar = btrim(bar) WHERE bar != btrim(bar)
should do it. That'll trim spaces - if you have a broader definition
of whitespace you should take a look at the docs for the btrim
function.
If this'll hit most of the rows on your table you probably want
to do a vacuum full (or a cluster) afterwards to recover all the
unused rows.
Cheers,
Steve
