Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14614: Combination of UNION, EXCEPT and ORDER BY produces an error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14614: Combination of UNION, EXCEPT and ORDER BY produces an error
Date
Msg-id 10269.1491581959@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14614: Combination of UNION,EXCEPT and ORDER BY produces an error  (sean.johnston@edgeintelligence.com)
List pgsql-bugs
Tree view 
sean.johnston@edgeintelligence.com writes:
> STATEMENT:  ( ( select 1,2,3 ) union ( select 4,5,6 order by 1,2 ) order by
> 1,2 ) except ( select 4,5,6 ) order by 1,2;
> ERROR:  no relation entry for relid 0

I've pushed a fix for this.  Thanks for the report!
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: sean.johnston@edgeintelligence.com
Date:
Subject: [BUGS] BUG #14614: Combination of UNION,EXCEPT and ORDER BY produces an error
Next
From: Noah Misch
Date:
Subject: [BUGS] Re: BUG #14600: Passwords in user mappings leaked by psql \deu+command