Made the change and used returns in both places now .. Gives me error
postgres=# \i a.sql
psql:a.sql:10: ERROR: language "plpgsql" does not exist
Any help is appreciated
Thx
Deep
create function loadme() returns text as '
Declare
s_out text ;
Begin
For i in 1..10000 loop
insert into test values (i,''Test'');
end loop;
returns s_out;
End;
' language 'plpgsql';
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alex Satrapa
Sent: Monday, January 12, 2004 4:57 PM
To: PostgreSQL General
Subject: Re: [GENERAL] Parse error help needed...
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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
