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