> 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

Reply via email to