Re: PLpgSQL: list of scalars as row for assign stmt, fore

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Pavel Stehule <pavel(dot)stehule(at)hotmail(dot)com>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-patches(at)postgresql(dot)org, neilc(at)samurai(dot)com
Subject: Re: PLpgSQL: list of scalars as row for assign stmt, fore
Date: 2005-12-21 04:09:02
Message-ID: 43A8D55E.9040801@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Pavel Stehule 2005-12-21 07:38:05 Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm
Previous Message Tom Lane 2005-12-21 04:04:51 Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm