Re: parse error in function

Hello John,

This happen when i run my function and I check for this characters. I have
only spaces.

Thursday, January 15, 2004, 3:29:35 PM, you wrote:

JSW> Have you got any funny characters in your function definition (like a TAB
JSW> character) - I can't tell from your e-mail.

JSW> I've seen problems before inserting function using psql when this is the
JSW> case.

JSW> John Sidney-Woollett

JSW> 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
>>