Re: Error with union in sub-selects

Hello,
some additional informations:

- if i execute the subselect alone, it works fine !.
- The same select statement works with sybase and oracle, so i think its a legal statement.
- After reading in the sql2-standard, i have found nothing which restricts unions in sub-selects.

(I don't want to use another rdbms ... i want to use PostgreSQL :-)))))

If somebody has a workaround, then i am the happiest person for the day.

cu
Martin

--
Martin Neimeier
Ingenieur-Buero Neimeier
Schwarzach / Germany
mailto:nei(at)ibn(dot)de / http://www.ibn.de (under heavy reconstruction)
Tel:+49(6262)912344 / Fax:+49(6262)912347