Re: Copying data from one column to another - Mailing list pgsql-general

Am Dienstag, den 01.11.2005, 16:03 -0700 schrieb Nels Lindquist:
> Hi there.
>
> Sorry if this is a silly question, I'm relatively new to PostgreSQL.
>
> I'm trying to copy information from one column, modify it and place
> it in another column.  Is there some shortcut way to do this with an
> UPDATE statement?

Yes, this is simply UPDATE.

UPDATE sometable SET somecolumn=somefunction(someothercolumn);