Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group