Message-ID: <431816D1.4060905@axis.hu>
Date: Fri, 02 Sep 2005 11:09:37 +0200
From: =?ISO-8859-2?Q?Graf_L=E1szl=F3?= <graf.laszlo@axis.hu>
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Returning with the inserted id
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 8bit

Hi all

A table was created with:
	CREATE TABLE test (
		id integer,
		nev varchar(25),
		datum timestamp
	);

A sequence to hold the id was defined with:
	CREATE SEQUENCE "public"."test_azon_seq"
		INCREMENT 1  MINVALUE 101
		MAXVALUE 9223372036854775807  START 101
		CACHE 1;

The function wich allocates the id and defines the datum is:
	CREATE FUNCTION test_verif() RETURNS trigger AS $test_verif$
		BEGIN
			select into NEW.id nextval('test_azon_seq');
			NEW.datum := current_timestamp;
			RETURN NEW;
		END;
	$test_verif$ LANGUAGE plpgsql;

and the before insert trigger is:
	CREATE TRIGGER test_verif
	  BEFORE INSERT ON test
	  FOR EACH ROW
	  EXECUTE PROCEDURE test_verif();


When I issue an insert (see below) how can I retrieve the
inserted value of id? I need something like Oracle's returns
for insert.

insert into "public"."test" (nev) values ('text');
-- 
László Graf