Re: Re: select to combine 2 tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
Cc: wsheldah(at)lexmark(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: select to combine 2 tables
Date: 2001-06-22 21:42:42
Message-ID: 5971.993246162@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Thomas T. Thai" <tom(at)minnesota(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thalis A. Kalfigopoulos 2001-06-22 21:45:17 no comment
Previous Message Vince Vielhaber 2001-06-22 21:41:40 Re: web site suggestion