Received: from carabosse.oleane.net (carabosse.oleane.net [194.2.28.5]) by hub.org (8.9.2/8.9.1) with ESMTP id RAA80743 for ; Fri, 26 Feb 1999 17:47:20 -0500 (EST) (envelope-from christophe.labouisse@dial.oleane.com) Received: from tom.oleane.net (tom.oleane.net [194.2.28.14]) by carabosse.oleane.net with ESMTP id XAA24347 for ; Fri, 26 Feb 1999 23:47:15 +0100 Received: from gabuzo.meunet (root@dyn-8-1-168.Def.dialup.oleane.fr [62.161.2.168]) by tom.oleane.net (8.8.8/8.8.8) with ESMTP id XAA31570 for ; Fri, 26 Feb 1999 23:47:09 +0100 Received: (from moi@localhost) by gabuzo.meunet (8.9.1a/8.9.1/Christophe Labouisse - 10/01/99) id XAA05792; Fri, 26 Feb 1999 23:45:00 +0100 To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Unique Number KEY References: <000901be61af$7018d800$ce9efea9@blneige> <36D6E70D.ACF4CB7D@digiro.net> Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: multipart/mixed; boundary="Multipart_Fri_Feb_26_23:45:00_1999-1" Content-Transfer-Encoding: 7bit From: Christophe Labouisse Date: 26 Feb 1999 23:45:00 +0100 In-Reply-To: CIMPOESU Teodor's message of "Fri, 26 Feb 1999 20:25:17 +0200" Message-ID: Lines: 24 X-Mailer: Gnus v5.5/XEmacs 20.4 - "Emerald" --Multipart_Fri_Feb_26_23:45:00_1999-1 Content-Type: text/plain; charset=US-ASCII CIMPOESU Teodor writes: > you have 2 ways to do it: > 1. try something like > CREATE TABLE STUDENTS( > studentID int4 DEFAULT 'int(now())', > studentName text ); Is suspect int(now()) to have a resolution of one second. Therefore this will not work if you insert more than one record in a second. --Multipart_Fri_Feb_26_23:45:00_1999-1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Christophe Labouisse : Cinéma, typographie, Unix christophe.labouisse@dial.oleane.com http://www.multimania.com/gabuzo/ Le cinéma en Lumière : http://www.lumiere.org/ --Multipart_Fri_Feb_26_23:45:00_1999-1--