Small function in PLPGSQL

From: Tirant Lo Blanc <tirantloblanc77(at)yahoo(dot)es>
To: pgsql-novice(at)postgresql(dot)org
Subject: Small function in PLPGSQL
Date: 2005-12-17 20:30:10
Message-ID: 20051217203010.72846.qmail@web26913.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2005-12-18 03:51:55 Re: Login problem
Previous Message Stephen Simpson 2005-12-17 20:10:45 Error connecting to database