Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql variable assignment not supporting distinct anymore - Mailing list pgsql-hackers

From Tom Lane
Subject Re: plpgsql variable assignment not supporting distinct anymore
Date
Msg-id 1171052.1611341990@sss.pgh.pa.us
Whole thread Raw
In response to Re: plpgsql variable assignment not supporting distinct anymore  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH 1/1] Fix detection of pwritev support for OSX.
Next
From: James Hilliard
Date:
Subject: [PATCH v3 1/1] Fix detection of preadv/pwritev support for OSX.