Postgres Pro
Downloads
Home   >   mailing lists

Thread: Small function in PLPGSQL

Small function in PLPGSQL

From
Tirant Lo Blanc
Date:
 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

Re: Small function in PLPGSQL

From
"Tjibbe Rijpma"
Date:
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