Re: [despammed] Serial data type

am  13.04.2005, um  9:30:09 -0600 mailte Walker, Jed S folgendes:
> I have several tables that require auto-generated Ids. I have noticed the
> serial and bigserial data types (or pseudo-types). These seem like they make
> things much simpler, but if you use this, how can you find out the the value
> of the serial column after you insert a row? Do you have to lookup the

Please read the manual about currval().


> primary key or is it stored in a session variable or some other place?  Is

In a squence, a extra database object.


> it better to define the sequence manually and just select it out by hand
> before doing the insert?

No. Why?

test_db=# create table seq_test (id serial, name varchar);
HINWEIS:  CREATE TABLE erstellt implizit eine Sequenz >>seq_test_id_seq<< f?r die >>serial<<-Spalte >>seq_test.id<<
CREATE TABLE
test_db=# insert into seq_test (name) values ('Andreas');
INSERT 373930 1
test_db=# insert into seq_test (name) values ('Anja');
INSERT 373931 1
test_db=# select * from seq_test;
 id |  name
----+---------
  1 | Andreas
  2 | Anja
(2 Zeilen)

test_db=#




Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===