From: | "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com> |
---|---|
To: | "Uros" <uros(at)sir-mag(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: parse error in function |
Date: | 2004-01-15 14:29:35 |
Message-ID: | 2193.192.168.0.64.1074176975.squirrel@mercury.wardbrook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Have you got any funny characters in your function definition (like a TAB
character) - I can't tell from your e-mail.
I've seen problems before inserting function using psql when this is the
case.
John Sidney-Woollett
Uros said:
> Hello!
>
> I have problem with my function and I can find what's wrong.
>
> WARNING: Error occurred while executing PL/pgSQL function
> fn_insert_entry_pending
> WARNING: line 26 at SQL statement
> ERROR: parser: parse error at or near "$1" at character 58
>
> create or replace function
> "fn_insert_entry_pending"(varchar,varchar,varchar,varchar,varchar,boolean,boolean,date,int,int)
> returns integer as '
> declare
> email alias for $1;
> caption alias for $2;
> description alias for $3;
> keywords alias for $4;
> url alias for $5;
> is_company alias for $6;
> is_novelty alias for $7;
> expire alias for $8;
> category1 alias for $9;
> category2 alias for $10;
> tmp record;
> id_entry_tmp integer;
>
> begin
> SELECT INTO tmp id_user FROM "user" WHERE id_user = email;
> if not found then
> execute ''INSERT INTO "user" (id_user) VALUES ('' ||
> quote_literal(email) || '')'';
> end if;
> select into id_entry_tmp id_entry from "directory_entry" where url=url
> and is_novelty=is_novelty;
>
> DELETE FROM "directory_entry_pending" WHERE "url"=url and
> "id_entry"=id_entry_tmp and "is_novelty"=is_novelty;
>
> INSERT INTO "directory_entry_pending"
> (id_entry,id_user,caption,url,is_company,is_novelty,expire,hash)
> VALUES (id_entry_tmp,$1,$2,$5,$6,$7,$8,''1'');
>
> return 1;
> end;
> ' language 'plpgsql';
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
From | Date | Subject | |
---|---|---|---|
Next Message | Uros | 2004-01-15 14:42:18 | Re: parse error in function |
Previous Message | Uros | 2004-01-15 14:25:23 | parse error in function |