select distinct a as F from table union select distinct b as F from table;
Note that UNION only returns the unique values of the union You can get repeated values by using UNION ALL.
-- Edmund Bacon <[EMAIL PROTECTED]>
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
