select a.name ... union select a.name ... order by a.name fails in 7.1 - Mailing list pgsql-bugs

From Palle Girgensohn
Subject select a.name ... union select a.name ... order by a.name fails in 7.1
Date
Msg-id 3AE355A0.F5FD48E@partitur.se
Whole thread Raw
List pgsql-bugs
Hi!

I'm not certain this is correct SQL, and I know the rewrite is
easy, but here is a difference I found between 7.0.3 and 7.1:

select a.name from users a
union
select a.name from oldusers a
order by a.userid;

ERROR:  Relation 'a' does not exist

This works fine in postgres 7.0.x

the simple rewrite is of course 'order by userid', but it is
tedious to find all places in our system where this happens. It
seems some programmers have used the above syntax a lot :(

Is it a bug, or was it a feature in 7.0?

/Palle
--
         Partitur Informationsteknik AB
Wenner-Gren Center             +46 8 566 280 02
113 46 Stockholm           +46 70 785 86 02
Sweden                   girgen@partitur.se

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: jdbc2 fails to getDate
Next
From: Palle Girgensohn
Date:
Subject: Re: select a.name ... union select a.name ... order by a.name fails in 7.1