"Thomas T. Thai" <tom@minnesota.com> writes:
> On Fri, 22 Jun 2001, Tom Lane wrote:
>
> > "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.
>
> 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.