Parse error help needed...
От | Thapliyal, Deepak |
---|---|
Тема | Parse error help needed... |
Дата | |
Msg-id | 1FE5193EE2768D478949FC0AFBFFC43B06EBDE05@mail-sd1.station.sony.com обсуждение исходный текст |
Ответы |
Re: Parse error help needed...
Re: Parse error help needed... |
Список | 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@node1]~$ createlang -d test -l Procedural languages Name | Trusted? ---------+---------- plpgsql | t (1 row) -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Chris Ochs Sent: Monday, January 12, 2004 4:30 PM To: pgsql-general@postgresql.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
В списке pgsql-general по дате отправления: