howto bypass the intersect + order by bug in 7.0.3

From: Jaume Teixi <teixi(at)6tems(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: howto bypass the intersect + order by bug in 7.0.3
Date: 2001-11-12 19:02:23
Message-ID: 20011112200223.2a4d3024.teixi@6tems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

Browse pgsql-hackers by date

  From Date Subject
Next Message Barry Lind 2001-11-12 19:12:47 Re: MD5-based passwords
Previous Message mlw 2001-11-12 18:35:52 Re: rename index?