| From: | teg(at)redhat(dot)com (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) |
|---|---|
| To: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org>, wsheldah(at)lexmark(dot)com |
| Subject: | Re: Re: select to combine 2 tables |
| Date: | 2001-06-23 02:42:11 |
| Message-ID: | xuyzoazlxx8.fsf@halden.devel.redhat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Thomas T. Thai" <tom(at)minnesota(dot)com> writes:
> On Fri, 22 Jun 2001, Tom Lane wrote:
>
> > "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.
>
> the project i'm doing this for is opensource and i need it to work in both
> postgresql and mysql. the above statement wouldn't work in mysql.
MySQL isn't close to SQL compatible.
--
Trond Eivind Glomsrød
Red Hat, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-06-23 02:56:33 | Re: Oracle to PostgreSQL Tool |
| Previous Message | Thomas T. Thai | 2001-06-23 02:25:35 | Re: Re: select to combine 2 tables |