Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.1/8.9.1) with ESMTP id GAA08975 for ; Wed, 27 Jan 1999 06:22:14 -0500 (EST) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id 262DE4B4AE; Wed, 27 Jan 1999 13:22:12 +0200 (IST) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA193B; Wed, 27 Jan 1999 13:23:15 +0200 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <4578.990127@webclub.ru> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 27 Jan 1999 13:22:22 +0200 To: novikov@webclub.ru, pgsql-sql From: Herouth Maoz Subject: Re: At 12:52 +0200 on 27/01/1999, You wrote: > For instance I have: > create table companies( > id serial primary key, > ... > ); > create table ccats( > cid integer not null references companies(id), > catid integer not null references categories(id) > ); > > What do I have to put instead of ??: > insert into companies values (??, ...); > insert into ccats (??, 5); > ... > insert into ccats (??, 7); Serial is in fact an integer, but it gets its default value from a sequence generator. As a general rule, don't use INSERT statement without saying each of the fields to which you want to enter a value. So, instead of using INSERT INTO companies VALUES (....); -- Bad Use INSERT INTO companies (id, field2, field3...) VALUES (....); -- Better Now it's very simple. All you have to do is not insert anything into the ID field: INSERT INTO companies (field2, field3...) VALUES (...); -- Best. Now, once you have inserted a row into the companies table, a number was generated for it automatically. As long as you are still connected to the database in the same connection, you can access this number via the function currval(); This function needs the name of the sequence generator as a parameter. To know the name of the sequence generator, do a \d after you create the companies table. For example, currval( 'id_seq' ) will give you the last number generated in the current session for the sequence generator 'id_seq'. So, the inserts for the ccats table become: INSERT INTO ccats (cid, catid) VALUES (currval( 'name of seq' ), 5 ); Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma