Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group