Postgres Pro
Downloads
Home   >   mailing lists

Re: Weird behaviour of ROLLUP/GROUPING - Mailing list pgsql-general

From Andrew Gierth
Subject Re: Weird behaviour of ROLLUP/GROUPING
Date
Msg-id 874la8lhvp.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Weird behaviour of ROLLUP/GROUPING  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Weird behaviour of ROLLUP/GROUPING  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-general
Tree view 
>>>>> "Guillaume" == Guillaume Lelarge <guillaume@lelarge.info> writes:

 Guillaume>   CASE grouping(to_char(b, 'MMYYYY'))

 Guillaume> ERROR:  arguments to GROUPING must be grouping expressions of the
 Guillaume> associated query level
 Guillaume> LINE 3: CASE grouping(to_char(b, 'MMYYYY')) WHEN 1 THEN 'some date' ...

 Guillaume> AFAICT, both queries should behave the same, though their
 Guillaume> actual behaviours are quite opposite. Working fine for the
 Guillaume> first, erroring out on the second.

 Guillaume> Does anyone has any idea what's going on here?

Not yet. But I will find out, since it seems to be a bug.

-- 
Andrew (irc:RhodiumToad)

pgsql-general by date:

Previous
From: aaaaaa
Date:
Subject: problem in regard to hot standby
Next
From: Alexey Bashtanov
Date:
Subject: Re: Array_agg and dimensions in Array