Message-ID: <43181C70.4040600@archonet.com>
Date: Fri, 02 Sep 2005 10:33:36 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317)
MIME-Version: 1.0
To: =?ISO-8859-2?Q?Graf_L=E1szl=F3?= <graf.laszlo@axis.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Returning with the inserted id
References: <431816D1.4060905@axis.hu>
In-Reply-To: <431816D1.4060905@axis.hu>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: quoted-printable

Graf L=E1szl=F3 wrote:
>=20
> 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;
>=20
> 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 :=3D current_timestamp;
>             RETURN NEW;
>         END;
>     $test_verif$ LANGUAGE plpgsql;

I take it this is just an example, because you could do this with=20
DEFAULTs on both columns.

> 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.
>=20
> insert into "public"."test" (nev) values ('text');

SELECT currval('public.test_azon_seq');

And yes, it will cope with multiple concurrent connections inserting.
--
   Richard Huxton
   Archonet Ltd