Re: Parse error help needed... - Mailing list pgsql-general

From Alex Satrapa
Subject Re: Parse error help needed...
Date
Msg-id 40034256.30107@lintelsys.com.au
Whole thread Raw
In response to Parse error help needed...  ("Thapliyal, Deepak" <dthapliyal@soe.sony.com>)
List pgsql-general
Thapliyal, Deepak wrote:
> create function loadme() return text as '

try "RETURNS" instead of "RETURN"

[the guys writing the function parser might want to consider reporting
what the parser was expecting at this point]

> Declare
>    s_out text ;
> Begin
>   For i in 1..10000 loop
>     insert into test values (i,''Test'');
>   end loop;
> return s_out;
> End;
> ' language 'plpgsql';

The rest looks fine (works for me - yes I tested it this time)

Alex Satrapa


pgsql-general by date:

Previous
From: "Thapliyal, Deepak"
Date:
Subject: Re: Parse error help needed...
Next
From: "Chris Ochs"
Date:
Subject: Re: sql insert function