Thread

Re: [HACKERS] 6.4 Aggregate Bug

Edmund Mergl <e.mergl@bawue.de> — 1998-08-01T14:04:26Z

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