Parse error help needed...

From: "Thapliyal, Deepak" <dthapliyal(at)soe(dot)sony(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Parse error help needed...
Date: 2004-01-13 00:40:34
Message-ID: 1FE5193EE2768D478949FC0AFBFFC43B06EBDE05@mail-sd1.station.sony.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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..10000 loop
insert into test values (i,''Test'');
end loop;
return s_out;
End;
' language 'plpgsql';

Any help is appreciated

Thx
Deep

PS: I already loaded pl/pgsql in my database
[postgres(at)node1]~$ createlang -d test -l
Procedural languages
Name | Trusted?
---------+----------
plpgsql | t
(1 row)

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Chris Ochs
Sent: Monday, January 12, 2004 4:30 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] sql insert function

Never mind, I forgot to quote the quote's...

Chris

> The documentation doesn't have any examples of using an sql language
> function to do an insert, andI am at loss as to I am doing wrong here.
> The error I get trying to create the function is: ERROR: syntax
> error at or near "$1" at character 148
>
> CREATE FUNCTION taxship(varchar,integer,varchar,float,float) returns
integer
> AS '
> insert into taxship(s_oid,order_id,mer_id,tax,shipping) values
> ('$1',$2,'$3',$4,$5); SELECT 1;
> ' LANGUAGE SQL;
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2004-01-13 00:44:18 Re: Parse error help needed...
Previous Message Doug McNaught 2004-01-13 00:35:53 Re: sql insert function