howto bypass the intersect + order by bug in 7.0.3

Started by Jaume Teixiabout 24 years ago1 messages
#1Jaume Teixi
teixi@6tems.com

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.