"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
>
