I have to deal with a table which contains:
first_name
surname
email1
email2
... and I would like to create a view which combines both email columns
thus:
first_name
surname
email
It looks simple but I can't think of an obvious query.
-----------------------------------------------------------
SELECT first_name, surname, ARRAY[email1, email2] AS email
FROM [...]
David J.
