howto bypass the intersect + order by bug in 7.0.3 - Mailing list pgsql-hackers

From Jaume Teixi
Subject howto bypass the intersect + order by bug in 7.0.3
Date
Msg-id 20011112200223.2a4d3024.teixi@6tems.com
Whole thread Raw
List pgsql-hackers
hi,
in one of my production servers with 7.0.3 now need to user order by on an intersect statement
> template1=# select relname from pg_class intersect select relname from pg_class order by relname;
> ERROR:  get_sortgroupclause_tle: ORDER/GROUP BY expression not found in targetlist
this is a bug that I can see ok with 7.1.2
but menwhile I can't upgrade this server, how could I bypass this bug ?

bests from barcelona,    jaume teixi.


pgsql-hackers by date:

Previous
From: Patrice Hédé
Date:
Subject: Re: Java's Unicode Notation
Next
From: Tom Lane
Date:
Subject: Re: Possible major bug in PlPython (plus some other ideas)