"Oleg" 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
The following bug has been logged online:
Bug reference: 4633
Logged by: Oleg
Email address: sero...@gmail.com
PostgreSQL version: PostgreSQL 8.3
Operating system: CentOS
Description:Bug in PL/PgSQL "SELECT .. INTO" statement parser
Details:
Here is an example:
CRE