Re: Final Patch for GROUPING SETS - unrecognized node type: 347

Поиск
Список
Период
Сортировка
От Erik Rijkers
Тема Re: Final Patch for GROUPING SETS - unrecognized node type: 347
Дата
Msg-id d19e1a7a64a631edd9ce0cc0da9bbd20.squirrel@webmail.xs4all.nl
обсуждение исходный текст
Ответ на Re: Final Patch for GROUPING SETS  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: Final Patch for GROUPING SETS - unrecognized node type: 347  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-hackers
On Mon, August 25, 2014 07:21, Andrew Gierth wrote:
> Here is the new version of our grouping sets patch. This version
> supersedes the previous post.

The patches did not apply anymore so I applied at 73eba19aebe0.  There they applied OK, and make && make check was OK.


drop   table if exists items_sold;
create table           items_sold as
select * from ( values      ('Foo', 'L', 10)    , ('Foo', 'M', 20)    , ('Bar', 'M', 15)    , ('Bar', 'L',  5)
) as f(brand, size, sales) ;

select brand, size, grouping(brand, size), sum(sales) from items_sold group by rollup(brand, size);   -->  WARNING:
unrecognizednode type: 347
 


I suppose that's not correct.


thanks,

Erik Rijkers




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: postgresql latency & bgwriter not doing its job
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: postgresql latency & bgwriter not doing its job