From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Greg Williamson <gwilliamson39(at)yahoo(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: trimming a column |
Date: | 2012-05-04 02:05:12 |
Message-ID: | 4FA33958.9070603@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 05/03/2012 06:55 PM, Greg Williamson wrote:
> Michael --
>
>> 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
>>
>
> The trim function needs to be told what sort of trim to do --
>
> Following the 9.1 manual (you did not specify which version of postgres you are using) try:
>
> UPDATE mytable SET id = trim(both ' ' from id).
Actually not:)
test=> SELECT length(trim(' test '));
length
--------
4
>
> (untested)
>
> See<http://www.postgresql.org/docs/9.1/static/functions-string.html>
>
> HTH,
>
> Greg Williamson
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2012-05-04 02:12:09 | Re: trimming a column |
Previous Message | Greg Williamson | 2012-05-04 01:55:02 | Re: trimming a column |