OLAP, Aggregates, and order of operations
От | mlw |
---|---|
Тема | OLAP, Aggregates, and order of operations |
Дата | |
Msg-id | 3B8520B1.8A9069A1@mohawksoft.com обсуждение исходный текст |
Ответы |
Re: OLAP, Aggregates, and order of operations
|
Список | pgsql-hackers |
I need to do some OLAP stuff, and I asked previously if there were a way to pass multiple parameters to an aggrigate function. i.e.: select mycube(value1, value2, value3) from table group by value1; I looked through the code and it is non-trivial to do, one would have to alter the grammar to include a number of parameters, I guess something like this: create aggregate (sfunc = myfunct, sfuncnargs=3, stype = int4, basetype1 = int4, basetype2 = int4, ....); Then change the catalog, and the execution, arrg! (God I wish I could spend the time I want on PostgreSQL! ) Anyway, short of that.... If I do this: select mycube(value1) as d1, dimention(value2) as d2, dimention(value3) as d3 group by value1; Can I safely assume the following: (1) mycube() will be called first (2) Assuming dimention() has no final func, that final func of mycube() will be called last.
В списке pgsql-hackers по дате отправления: