Re: query ... returned 4 columns

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