[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] query ... returned 4 columns
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2007-03-08 16:08:04
Message-ID: 8071.1173370084 () sss ! pgh ! pa ! us
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match
[prev in list] [next in list] [prev in thread] [next in thread]