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
|
| Список | 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 по дате отправления: