Re: [BUGS] BUG #14693: create materialized view forces btrim

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [BUGS] BUG #14693: create materialized view forces btrim
Дата
Msg-id CAKFQuwZa82r7L+z6QfW9O+jg9H_iuwhTgWLoo9HRK5KLvrJ1Jw@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14693: create materialized view forces btrim  (isb0459@gmail.com)
Список pgsql-bugs
Дерево обсуждения
On Tue, Jun 6, 2017 at 1:25 PM, <isb0459@gmail.com> wrote:
I am trying to create a materialized view. I have a working SQL query that
uses this expression: coalesce(trim(foo), bar). When I use that in the
definition for create materialized view, Postgres force replaces the trim()
call into a btrim() and breaks the query result.

Given your subsequent descriptions I'm confused as to your claim that you have a working SQL query when not used as part of a create materialized view.​  You should have found that running the same simple select by itself was always returning empty foo strings instead of bar.

David J.

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

Предыдущее
От: Mike Palmiotto
Дата:
Сообщение: Re: [BUGS] BUG #14682: row level security not work with partitioned table
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [BUGS] [PATCH] Fixed malformed error message on malformed SCRAMmessage.