Bug: aliasing in ORDER BY when UNIONing - Mailing list pgsql-hackers

What works:

# select o.id from op o order by o.id;
# select o.id from op o union all SELECT -1 order by id;

Does not work:

# select o.id from op o union all SELECT -1 order by o.id;
ERROR:  Relation 'o' does not exist
# select o.id from op o union all SELECT -1 from op o order by o.id;
ERROR:  Relation 'o' does not exist


Running today's CVS.  (I finally converted my main workstation
to 7.1...)

-- 
marko