Re: Parse error help needed...

From: Alex Satrapa <alex(at)lintelsys(dot)com(dot)au>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Parse error help needed...
Date: 2004-01-13 00:56:54
Message-ID: 40034256.30107@lintelsys.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Ochs 2004-01-13 01:09:10 Re: sql insert function
Previous Message Thapliyal, Deepak 2004-01-13 00:48:38 Re: Parse error help needed...