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

From David Fetter
Subject Re: PLpgSQL: list of scalars as row for assign stmt, fore
Date
Msg-id 20051221013832.GA30262@fetter.org
Whole thread Raw
In response to Re: PLpgSQL: list of scalars as row for assign stmt, fore  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-patches
On Wed, Dec 21, 2005 at 09:26:35AM +0800, Christopher Kings-Lynne 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;

Better still, the pg way:

[ROW](x, y) := r;

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 415 235 3778

Remember to vote!

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: tuple count and v3 functions in psql for COPY
Next
From: Volkan YAZICI
Date:
Subject: Re: tuple count and v3 functions in psql for COPY