Horton

Re: [HACKERS] 6.4 Aggregate Bug

Edmund Mergl <e.mergl@bawue.de>

View thread
From: Edmund Mergl <E.Mergl@bawue.de>
To: David Hartwig <daybee@bellatlantic.net>
Cc: hackers <pgsql-hackers@postgreSQL.org>
Date: 1998-08-01T14:04:26Z
Lists: pgsql-hackers 
David Hartwig wrote:
> 
> While testing  my 6.4 patch to allow functions/expressions to be
> specified in the ORDER/GROUP BY  clause (and not in the target list)  I


will this patch allow the following syntax :

  select count(SUBSTR(var,1,5)), SUBSTR(var,1,5) from t group by SUBSTR(var,1,5);

This is important for writing database-independent code (e.g. it's the only
syntax Oracle understands).

Edmund
-- 
Edmund Mergl          mailto:E.Mergl@bawue.de
Im Haldenhau 9        http://www.bawue.de/~mergl
70565 Stuttgart       fon: +49 711 747503
Germany