Re: PLpgSQL: list of scalars as row for assign stmt, fore - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: PLpgSQL: list of scalars as row for assign stmt, fore
Date
Msg-id 43A8D55E.9040801@familyhealth.com.au
Whole thread Raw
In response to Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
List pgsql-patches

Pavel Stehule wrote:
>>>>    x, y := r;
>>>
>>>
>>> That strikes me as a really bad idea.  It weakens both syntax and
>>> semantic error checking, to accomplish how much?
>>
>>
>> Could use PHP-style thingy:
>>
>> LIST(x, y) := r;
>>
>> Chris
>>
>
> It's inconsystency :-(.
>
> EXECUTE INTO and SELECT INTO use scalar of vectors without anything.

ROW(x, y) := r;

:)

Chris


pgsql-patches by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm
Next
From: Tom Lane
Date:
Subject: Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm