Postgres Pro
Downloads
Home   >   mailing lists

Re: query ... returned 4 columns - Mailing list pgsql-general

From Tom Lane
Subject Re: query ... returned 4 columns
Date
Msg-id 8071.1173370084@sss.pgh.pa.us
Whole thread Raw
In response to query ... returned 4 columns  (Sorin Schwimmer <sxn02@yahoo.com>)
List pgsql-general
Tree view 
Sorin Schwimmer <sxn02@yahoo.com> writes:
>   DECLARE
>     o expected_stuff%ROWTYPE;
>   BEGIN
>     o:= * FROM expected_stuff WHERE packslip=$1; --

Use
    SELECT * INTO o FROM expected_stuff WHERE ...

The assignment syntax is currently only supported for scalar values,
I believe.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: which is more scalable for the database?
Next
From: Richard Huxton
Date:
Subject: Re: foreign key support for inheritance