Received: from chi-mx.truenorth.com (interlock.truenorth.com [199.221.98.2]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA83728 for ; Wed, 8 Sep 1999 14:08:37 -0400 (EDT) (envelope-from djackson@cpsgroup.com) Received: from cpsmail.cpsgroup.com (cpsmail.cpsgroup.com [144.210.12.10]) by chi-mx.truenorth.com (8.9.3/8.9.3) with ESMTP id NAA20257; Wed, 8 Sep 1999 13:09:09 -0500 (CDT) Received: by cpsmail with Internet Mail Service (5.5.2448.0) id ; Wed, 8 Sep 1999 13:08:23 -0500 Message-ID: From: "Jackson, DeJuan" To: Hroi Sigurdsson Cc: pgsql-sql@postgreSQL.org Subject: RE: [SQL] DEFAULT confusion Date: Wed, 8 Sep 1999 13:08:23 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain > -----Original Message----- > From: Hroi Sigurdsson [SMTP:hroi@ninja.dk] > Sent: Tuesday, September 07, 1999 9:40 PM > To: pgsql-sql@postgreSQL.org > Subject: [SQL] DEFAULT confusion > > Hello postgresql'ers (how do you pronounce that?). > > Suppose i have the following sequence, table and index: > > CREATE SEQUENCE stuff_seq; > CREATE TABLE stuff ( > id INTEGER DEFAULT NEXTVAL('stuff_seq') NOT NULL, > name TEXT, > number INTEGER > ); > CREATE UNIQUE INDEX stuff_id ON tabel(id); > > Then to properly insert rows i have to > > INSERT INTO tabel VALUES (NEXTVAL('tabel_seq'), "sometext", 123); Change the above line to: INSERT INTO stuff(name, number) VALUES ('sometext', 123); Hope this helps, DEJ > I can't just > INSERT INTO tabel VALUES (NULL, "something", 123); > > Then what is the point of the DEFAULT clause? In other words: How do I > get away with not specifying anything for id? And how (if > possible/recommendable) do I force the id value to be nothing but > NEXTVAL('stuff_seq'), ie. not just an arbitrary number? > > In short I want to emulate MySQL's way of doing > CREATE TABLE( > id INT NOT NULL AUTO_INCREMENT, > name TEXT, > int INT, > UNIQUE(id) > ); > > I hope I made myself sufficiently clear. > > Thank you for your time. > > > PS. > Where can I get more information about the REFERENCES keyword and when > will it be fully working in Postgres? > PPS. > Are there any books out there that cover Postgresql? > -- > Hroi Sigurdsson > hroi@ninja.dk > > ************