"Thomas T. Thai" <tom@minnesota.com> writes:
>> Use a union query:
>>
>> select rec_id, path, '' as link, name from cat_cat
>> UNION
>> select rec_id, path, link, name from cat_alias
> there is no way to do this in a generic DBI way? i need for this to work
> across diff kind of DBs.
Huh? That *is* the generic, fully-SQL-standard way.
regards, tom lane