"Oleg" <sero...@gmail.com> writes:
> DECLARE
> row_test1 test1%rowtype;
> row_test2 test2%rowtype;
> BEGIN
> SELECT test1, test2
> FROM test1 JOIN test2 ON(chunk.id = test2.chunk_id)
> LIMIT 1
> INTO row_test1, row_test2;
Can't do that. The INTO target can be either a row variable or a list
of scalar variables ... not a list of row variables.
You could probably make it work by just making the target be a "record"
variable that'd wind up containing two composite fields.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
