pgpsql help

[LENGYEL Zoltan <warnew@xxxxxxxxxxxxxxxx>]

Hi,

I have a pgpsql function:

create or replace function new_uri(varchar,varchar,varchar) returns 
integer as '
declare
  src alias for $1;
  tit alias for $2;
  uri alias for $3;
  article_id integer := nextval(''articleid'');
  src_id integer;
  state_id integer;
  urit_id integer;
begin

select into src_id   id from sources where name = src;
select into state_id id from state   where name = ''collected'';
select into urit_id  id from uritype where name = ''original html'';
raise notice ''insert into article (id,source,title,state) values 
(%,%,%,%)'',article_id,src_id,tit,state_id;
insert into article (id,source,title,state) values 
(article_id,src_id,tit,state_id);
raise notice ''insert into uri (articleid,uri,uritype) values 
(%,%,%)'',article_id,uri,urit_id;
insert into uri (articleid,uri,uritype) values (article_id,uri,urit_id);

return 1;
end;
' language 'plpgsql';

An i also have some output:

ifa=> \i new_uri.sql
CREATE FUNCTION
ifa=> select new_uri('index.hu','juscsenko','index.hu/foobar');
NOTICE:  insert into article (id,source,title,state) values 
(56,3,juscsenko,1)
NOTICE:  insert into uri (articleid,uri,uritype) values 
(56,index.hu/foobar,3)
ERROR:  syntax error at or near "$1" at character 14
CONTEXT:  PL/pgSQL function "new_uri" line 17 at SQL statement
ifa=>

What should i do?


thx,

War_New

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
     message can get through to the mailing list cleanly