Postgres Pro
Downloads
Home   >   mailing lists

Re: AW: AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVIN G - Mailing list pgsql-hackers

From Tom Lane
Subject Re: AW: AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVIN G
Date
Msg-id 24289.945354228@sss.pgh.pa.us
Whole thread Raw
In response to AW: AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVIN G  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
Tree view 
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.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

pgsql-hackers by date:

Previous
From: Tim Holloway
Date:
Subject: Re: [HACKERS] Postmaster options, process spawning, logging, etc.
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] initdb / pg_version