Received: from ns.krot.org (ns.krot.org [193.212.103.165]) by postgresql.org (8.11.3/8.11.4) with SMTP id f9PLP9P73932 for ; Thu, 25 Oct 2001 17:25:14 -0400 (EDT) (envelope-from postgresql@envisity.com) Received: (qmail 16938 invoked by uid 67); 25 Oct 2001 21:22:44 -0000 Message-ID: <20011025212244.2041.qmail@ns.krot.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline MIME-Version: 1.0 From: "Aasmund Midttun Godal" To: green@usa.dp.ua Cc: pgsql-sql@postgresql.org Subject: Re: autoincrement Date: Thu, 25 Oct 2001 21:22:44 GMT X-Mailer: Googley-Moogley In-Reply-To: <20011025230932.A82025@usa.dp.ua> from Alexey Prohorenko on Thu, 25 Oct 2001 23:09:32 +0300 References: <20011025230932.A82025@usa.dp.ua> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f9PLVGM75052 X-Archive-Number: 200110/362 X-Sequence-Number: 5315 SERIAL type (look it up in the docs). Regards, Aasmund PS. I may not be good at counting, but I have counted your two words 3 times and I still get 6. On Thu, 25 Oct 2001 23:09:32 +0300, Alexey Prohorenko wrote: > How can I reproduce in PostgreSQL type structure from MySQL: > INT NOT NULL PRIMARY KEY AUTO_INCREMENT > > ? > > To be more exact -- in two words: "how can I create autoincrement > field?" > > Thanks a lot. > > -- > green > [http://www.extrasy.net] > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org Aasmund Midttun Godal aasmund@godal.com - http://www.godal.com/ +47 40 45 20 46