> Only the first SELECT is used to define column types and names (in the case > of NULL AS source2_* I am not positive if you need to cast the NULL or if it > will use the type found in the second SELECT) and I generally put a "source" > field into the output with a textual representation of which table the record > originated from. >
Seems like it would be more efficient just to create a table (temp or otherwise) with and pump data into that. Anyway thanks for the help. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general