Received: from news.tht.net (news.hub.org [216.126.91.242]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA72200 for ; Wed, 17 May 2000 20:52:52 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.9.3/8.9.3) id UAA64532 for pgsql-sql@postgresql.org; Wed, 17 May 2000 20:52:52 -0400 (EDT) (envelope-from news) X-Authentication-Warning: news.tht.net: news set sender to using -f Message-ID: <39233EE0.D7618BB2@clacknet.com> From: Daniel Mendyke Reply-To: daniel@nospam.clacknet.com X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdk i686) X-Accept-Language: en MIME-Version: 1.0 X-Newsgroups: comp.databases.postgresql.sql Subject: Automatic index numbers Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 17 X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly X-Complaints-To: support@usenetserver.com Organization: WebUseNet Corp http://www.usenetserver.com - Home of the fastest NNTP servers on the Net. Date: Wed, 17 May 2000 17:52:48 -0700 To: pgsql-sql@postgresql.org X-Archive-Number: 200005/39 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 -- To reach me remove the 'nospam.' from my address. I can be reached at 'daniel at clacknet dot com'