"Oleg" writes:
> DECLARE
>row_test1 test1%rowtype;
>row_test2 test2%rowtype;
> BEGIN
>SELECT test1, chunk_id
>FROM test1 JOIN test2 ON(chunk.id = test2.chunk_id)
>LIMIT 1
>INTO row_test1, row_test2;
> Will throw error:
> ERROR: LIMIT #,# syntax is not supporte
On Mon, Mar 1, 2010 at 02:22, Oleg wrote:
> CREATE OR REPLACE FUNCTION "bug" () RETURNS pg_catalog.void AS
> $body$
> DECLARE
> row_test1 test1%rowtype;
> row_test2 test2%rowtype;
> BEGIN
> SELECT test1, chunk_id
> FROM test1 JOIN test2 ON(chunk.id = test2.chunk_id)
> LIMIT 1
>
The following bug has been logged online:
Bug reference: 5352
Logged by: Oleg
Email address: sero...@gmail.com
PostgreSQL version: any
Operating system: any
Description:Bug in PL/PgSQL "SELECT .. INTO" statement parser
Details:
CREATE TABLE test2 (
id BIGINT,
