Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA33202 for ; Sun, 27 Feb 2000 19:31:41 -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 TAA11427; Sun, 27 Feb 2000 19:19:27 -0500 (EST) From: Bruce Momjian Message-Id: <200002280019.TAA11427@candle.pha.pa.us> Subject: Re: [SQL] INSERT w/o variable names for a SERIAL type? In-Reply-To: from Peter Eisentraut at "Feb 28, 2000 01:00:31 am" To: Peter Eisentraut Date: Sun, 27 Feb 2000 19:19:27 -0500 (EST) CC: Tom Lane , 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...] > Tom Lane writes: > > > > INSERT INTO my_table VALUES (a, b, c, DEFAULT, x, y, z, ...); > > > > I think that is legal SQL92 syntax, but Postgres doesn't accept it > > at present. > > Oops! > > We do support INSERT .. DEFAULT VALUES, so I guessed too far. We do? What does the DEFAULT do? -- 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