Re: Weird behaviour of ROLLUP/GROUPING

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Weird behaviour of ROLLUP/GROUPING
Дата
Msg-id 874la8lhvp.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Weird behaviour of ROLLUP/GROUPING  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: Weird behaviour of ROLLUP/GROUPING  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-general
>>>>> "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 по дате отправления:

Предыдущее
От: aaaaaa
Дата:
Сообщение: problem in regard to hot standby
Следующее
От: Alexey Bashtanov
Дата:
Сообщение: Re: Array_agg and dimensions in Array