Horton

Re: [HACKERS] Some progress on INSERT/SELECT/GROUP BY bugs

Zeugswetter Andreas <andreas.zeugswetter@telecom.at>

View thread
From: ZEUGSWETTER Andreas IZ5 <Andreas.Zeugswetter@telecom.at>
To: pgsql-hackers@postgreSQL.org
Date: 1999-05-19T11:36:26Z
Lists: pgsql-hackers 
> I still am unclear which of these are valid SQL:
> 
> 	select a as b from test order by a
> 	select a as b from test order by b
> 
Both are valid, and don't forget the third variant:

> select a as b from test order by 1
> 
Andreas