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.