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

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 -----
From: Tirant Lo Blanc
To: pgsql-novice@postgresql.org
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