Received: from merganser.its.uu.se (merganser.its.uu.se [130.238.6.236]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA68628 for ; Sun, 27 Feb 2000 10:16:37 -0500 (EST) (envelope-from peter@localhost.its.uu.se) Received: from regulus.its.uu.se ([130.238.7.19]:62710 "EHLO regulus.its.uu.se") by merganser.its.uu.se with ESMTP id ; Sun, 27 Feb 2000 16:15:50 +0100 Received: from peter (helo=localhost) by regulus.its.uu.se with local-esmtp (Exim 3.02 #2) id 12P5Sy-0000gM-00; Sun, 27 Feb 2000 16:18:40 +0100 Date: Sun, 27 Feb 2000 16:18:39 +0100 (CET) From: Peter Eisentraut To: Emils Klotins cc: pgsql-sql@postgresql.org Subject: Re: [SQL] INSERT w/o variable names for a SERIAL type? In-Reply-To: <200002251428.QAA06635@www.usis.bkc.lv> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-1 Content-Transfer-Encoding: 8BIT Sender: Peter Eisentraut 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, ...); -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden