trimming a column

["Michael P. Soulier" <michael_soulier@xxxxxxxxx>]

Hi,

I need to trim whitespace off of a whole column and replace the existing
values with the trimmed ones.

This isn't working

update mytable set id = trim(id);

I'm not sure of the correct syntax. Help appreciated.

Mike

Attachment: signature.asc
Description: Digital signature