om: Larry Rosenman [mailto:[EMAIL PROTECTED]
Sent: Monday, January 12, 2004 5:29 PM
To: Thapliyal, Deepak; 'PostgreSQL General'
Subject: Re: [GENERAL] Parse error help needed...
--On Monday, January 12, 2004 17:24:14 -0800 "Thapliyal, Deepak"
<[EMAIL PROTECTED]> wro
AIL 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&qu
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 Gene
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..1 loop
insert into test val
c: '[EMAIL PROTECTED]'
Subject: Re: [GENERAL] Parse error help needed...
"Thapliyal, Deepak" <[EMAIL PROTECTED]> writes:
> I am getting this error
>
> postgres=# \i a.sql
> psql:a.sql:10: ERROR: parser: parse error at or near "return" at
"Thapliyal, Deepak" <[EMAIL PROTECTED]> writes:
> I am getting this error
>
> postgres=# \i a.sql
> psql:a.sql:10: ERROR: parser: parse error at or near "return" at character
> 26
> create function loadme() return text as '
^^
I think you want "returns" here.
-D
I am getting this error
postgres=# \i a.sql
psql:a.sql:10: ERROR: parser: parse error at or near "return" at character
26
--
a.sql
--
create function loadme() return text as '
Declare
s_out text ;
Begin
For i in 1..1 loop
insert into test values (i,''Test'');
end loop;
return s_
