Re: Trying to write a function... - Mailing list pgsql-sql

Wim,

> CREATE FUNCTION f_addrtr (varchar(16),varchar(32)) RETURNS bool AS '
> DECLARE
> index int4;
> BEGIN
> index := 'nextval('s_routerid')';
> INSERT INTO t_routers VALUES (index, $1, $2);
> RETURN 1;
> END;'
> LANGUAGE 'plpgsql';
>
> What am I doing wrong?

Bad quotes, bad data type usage.  Change as follows:

CREATE FUNCTION f_addrtr (varchar(16),varchar(32)) RETURNS bool AS '
DECLARE
index int4;
BEGIN
index := nextval(''s_routerid'');INSERT INTO t_routers VALUES (index, $1, $2);RETURN TRUE;
END;'LANGUAGE 'plpgsql';


--
-Josh BerkusAglio Database SolutionsSan Francisco