Received: from candle.pha.pa.us (pgman@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA03054 for ; Sun, 27 Feb 2000 13:59:05 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id NAA00857; Sun, 27 Feb 2000 13:58:44 -0500 (EST) From: Bruce Momjian Message-Id: <200002271858.NAA00857@candle.pha.pa.us> Subject: Re: [SQL] INSERT w/o variable names for a SERIAL type? In-Reply-To: from Peter Eisentraut at "Feb 27, 2000 04:18:39 pm" To: Peter Eisentraut Date: Sun, 27 Feb 2000 13:58:43 -0500 (EST) CC: Emils Klotins , pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL72 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit [Charset ISO-8859-1 unsupported, filtering to ASCII...] > Emils Klotins writes: > > > Now, if I want to write a general #define, I'd need to have a way > > to specify 'default' for SERIAL field, for, if I omit the id field in > > VALUES, I need to specify all the rest of the fields explicitly. > > > > Is there any value I could put in place of id in VALUES part, to > > make it replaced with the next value in sequence? > > INSERT INTO my_table VALUES (a, b, c, DEFAULT, x, y, z, ...); I didn't think that worked, and it doesn't seem to work. Should it? test=> create table j(x serial, y char(10))\g NOTICE: CREATE TABLE will create implicit sequence 'j_x_seq' for SERIAL column 'j.x' NOTICE: CREATE TABLE/UNIQUE will create implicit index 'j_x_key' for table 'j' CREATE test=> insert into j values (default,'yes'); ERROR: parser: parse error at or near "default" -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026