information "what is it" and
"how thos work". May be i stupid.
Sorry.
2009/8/14 Pavel Stehule :
> 2009/8/14 Олег Царев :
>> 2009/8/14 Hitoshi Harada :
>>> 2009/8/14 Pavel Stehule :
>>>> 2009/8/13 Hitoshi Harada :
>>>>> 2009/8/14 Pave
2009/8/14 Hitoshi Harada :
> 2009/8/14 Pavel Stehule :
>> 2009/8/13 Hitoshi Harada :
>>> 2009/8/14 Pavel Stehule :
I prefered using CTE, because this way was the most short to small
bugs less prototype - with full functionality.
>>>
>>> You could make it by query rewriting, but as you say
2009/8/13 Hitoshi Harada :
> 2009/8/8 Alvaro Herrera :
>> Олег Царев escribió:
>>> Hello all!
>>> If no one objecte (all agree, in other say) i continue work on patch -
>>> particulary, i want support second strategy (tuple store instead of
>>> has
enhancing current Aggregate
> node for support of GroupingSets. The code base on UNION ALL is +/-
> equal to CTE, and I don't thing, so this should be optimal. But work
> freely, please. I have not free time for this patch next two months.
> So if you have time, it's your
ormation i will can continue discussion.
Thanls
2009/5/10 Pavel Stehule :
> 2009/5/10 Олег Царев :
>> Hello, Pavel.
>>
>> I read you letter, and found some points:
>>
>> a) Simple transformation any GROUPING SETS in GROUP BY + UNION ALL
>> require clone source
'll have some a prototype based on CTE. My older
> technique based on hashed tables should be well, but it carry lot of
> unshared code. Using CTE means so we can optimize CTE and GROUPING
> SETS together. I plan to transform query
>
> SELECT * FROM some GROUP BY GROUPING SETS(a, b)
&
Hello all.
Please, approve my ideas for implementation.
Standart has feature T431: Extended grouping capabilities.
This feature i found in TODO-list:
http://wiki.postgresql.org/wiki/Todo -> SQL Commands -> TO DO
MS SQL 2005 partial support this feature:
http://www.kodyaz.com/articles/sql-server-2
Hello all!
I need help in study internal structures of PosrgreSQL. Sorry for my bad
english.
I try to get information from source code and spend five days for that, but
now have many questions and few understanding =(
Source code it's clear, great commented, but studing so difficult system as
DBMS
