Received: from eba-haus.de ([149.228.241.81]) by hub.org (8.9.3/8.9.3) with SMTP id DAA99296 for ; Thu, 18 May 2000 03:00:22 -0400 (EDT) (envelope-from DieringG@eba-haus.de) Received: from kopo001 by eba-haus.de;Thu, 18 May 2000 06:52:48 GMT with Novell_GroupWise; Thu, 18 May 2000 08:52:48 +0200 Message-Id: X-Mailer: Novell GroupWise 5.5.2 Date: Thu, 18 May 2000 08:52:32 +0200 From: "Gerhard Dieringer" To: , Subject: Antw: Automatic index numbers Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id DAB01965 X-Archive-Number: 200005/41 >>> daniel@clacknet.com 18.05.2000 02.52 Uhr >>> > > How can I automatically create a unique index > number when I add new data to a table? > > Does this have to be done through a high level > language or does the database provide a function > for this? > > -Daniel You can use a column with datatype serial or an integer with default nextval('a_sequence') Gerhard