"Oleg" <serovOv(at)gmail(dot)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