On Wed, 06 Nov 2024 17:30:02 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> [...]
>
> You have the syntax wrong: what you intended (I presume) is
>
> SELECT a, b INTO STRICT r FROM (SELECT 'A' AS a, 'B' AS b) AS q;
>
> With what you wrote, the STRICT is taken as an output column alias of
> the outer SELECT, [...]
>
> regards, tom lane
Oooops, my apologies! It totally makes sense now.
Thanks for your thorough/helpful response.
Regards
Jan Behrens