Bug: aliasing in ORDER BY when UNIONing

From: Marko Kreen <marko(at)l-t(dot)ee>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Bug: aliasing in ORDER BY when UNIONing
Date: 2001-02-19 00:53:57
Message-ID: 20010219025357.A3588@l-t.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-02-19 01:19:15 Re: PHP 4.0.4pl1 / Beta 5
Previous Message Mitch Vincent 2001-02-19 00:00:28 PHP 4.0.4pl1 / Beta 5