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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
