CREATE FUNCTION insert_row (VARCHAR, VARCHAR) RETURNS INT AS '
DECLARE
id INT;
BEGIN;
id := nextval('seq');
INSERT INTO table VALUES (id, $1, $2);
RETURN id;
END
LANGUAGE plpqsql;
----- Original Message -----
Sent: Saturday, December 17, 2005 21:30
Subject: [NOVICE] Small function in PLPGSQL
Hello, I'm learning plpsql and have a question:
I would like to create a function that inserts a new record on my invoice table.
This table has an id (serial type).
I would like this function to return de id assigned to the new record.
any ideas?
Thanks, and excuse my poor English.
Correo Yahoo!
Comprueba qué es nuevo, aquí
http://correo.yahoo.es