Re: AW: AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVIN G

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
Cc: "'pgsql-hackers(at)postgreSQL(dot)org'" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: AW: AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVIN G
Date: 1999-12-16 14:23:48
Message-ID: 24289.945354228@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> writes:
> Informix and DB/2 allow column numbering in the group by clause.

What do they do with

SELECT foo AS bar FROM table GROUP BY bar

?

What do they do if bar is the real name of another column in the table?

regards, tom lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Edwin Ramirez 1999-12-16 14:24:14 Oracle Compatibility (Translate function)
Previous Message Tim Holloway 1999-12-16 13:28:43 Re: [HACKERS] Postmaster options, process spawning, logging, etc.