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

From Wim
Subject Trying to write a function...
Date
Msg-id 3D3EFBB1.9040904@belbone.be
Whole thread Raw
Responses Re: Trying to write a function...  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Hello,

I'm trying to write a function that add new rows to a table, but I don't 
succeed.....
It's something like this:

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?


Cheers!

Wim.



pgsql-sql by date:

Previous
From: Chris Ruprecht
Date:
Subject: Re: Last record
Next
From: Tom Lane
Date:
Subject: Re: RES: RES: Queries not using Index