subject:"\[SQL\] Returning with the inserted id"

Re: [SQL] Returning with the inserted id

2005-09-02 Thread Richard Huxton

Graf László wrote: 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_ve

[SQL] Returning with the inserted id

2005-09-02 Thread Graf László

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