I was hopping that in a SELECT I could replace the data from the email
column to something else...
maybe email = name_first + name_last? Is that possible?
I can't overwrite the data into that column... that has to be done by
the select (if possible)
SELECT <item1>, <item2>, ..., name_first || ' ' || name_last AS email
FROM ...
You can't use SELECT *, you must list everything but email.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
