howto bypass the intersect + order by bug in 7.0.3
Started by Jaume Teixiabout 24 years ago1 messages
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.