
> Which dbms's allow it?  Or is there an error in my query (I don't
> use column numbering, I'm into names myself)?

Informix and DB/2 allow column numbering in the group by clause.

Andreas

Thu, 16 Dec 1999 09:30:23 +0100
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVIN
	G
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

Thu, 16 Dec 1999 09:23:48 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: AW: AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVIN
	G