Done: Bug 675377 Although I don't think it's a Postgres specific fix? >From my understanding, it's more "correct" to say: count(distinct (a,b,c)) as opposed to count(distinct a,b,c)
and so all databases should accept the syntax with the () around the column names? Hence it can be a generic fix rather than a Postgres specific one? I could be wrong though :-) On 12/11/10 23:23, Gustavo Niemeyer wrote: > Hi Ian, > >> select count(distinct a,b,c) from A where xxx >> >> From my understanding, the above sql is not valid for Postgres, although >> it works with other databases like mysql etc. What Postgres wants is this: >> >> select count(distinct (a,b,c)) from A where xxx > > Can you please file a bug about this? We'll likely have to modify the > way the postgres backend is compiling this expression. > -- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
