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