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

Reply via email to