Re: plpgsql variable assignment not supporting distinct anymore

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql variable assignment not supporting distinct anymore
Дата
Msg-id 1171052.1611341990@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: plpgsql variable assignment not supporting distinct anymore  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Pavel Stehule <pavel.stehule@gmail.com> writes:
> pá 22. 1. 2021 v 14:41 odesílatel <easteregg@verfriemelt.org> napsal:
>> ERROR:  syntax error at or near "DISTINCT"
>> LINE 8:     _test := DISTINCT a FROM ( VALUES ( (true), ( true ) ) )...

> Using DISTINCT is not a good solution.

Yeah.  It wouldn't be as painful to support this in the grammar
as it would be for UNION et al, so maybe we should just do it.
But I still find this to be mighty ugly plpgsql code.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH 1/1] Fix detection of pwritev support for OSX.
Следующее
От: James Hilliard
Дата:
Сообщение: [PATCH v3 1/1] Fix detection of preadv/pwritev support for OSX.