howto bypass the intersect + order by bug in 7.0.3
Jaume Teixi <teixi@6tems.com>
From: Jaume Teixi <teixi@6tems.com>
To: pgsql-hackers@postgresql.org
Date: 2001-11-12T19:02:23Z
Lists: 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.