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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org