Re: BUG #14301: function in case expression called when it should not be

Поиск
Список
Период
Сортировка
От Rikard Pavelic
Тема Re: BUG #14301: function in case expression called when it should not be
Дата
Msg-id 20160829225304.00004ba6@ngs.hr
обсуждение исходный текст
Ответ на Re: BUG #14301: function in case expression called when it should not be  (David Fetter <david@fetter.org>)
Список pgsql-bugs
Дерево обсуждения 
On Mon, 29 Aug 2016 13:44:19 -0700
David Fetter <david@fetter.org> wrote:

> This is the expected behavior.  You might look into FILTER clauses in
> your queries, which might be closer to the behavior you want.

Yeah, I realized why it's behaving that way after Tom's answer.
I did not write such horrible code, but I worked around it by repeating
case when within the sum :)

Regards,
Rikard

--
Rikard Pavelic
https://dsl-platform.com/
http://templater.info/

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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: BUG #14301: function in case expression called when it should not be
Следующее
От: chenkaijiang@gmail.com
Дата:
Сообщение: BUG #14302: SQL with LIMIT degrades performance seriously