X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 581A052968 for ; Thu, 23 Jun 2005 09:44:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30517-10 for ; Thu, 23 Jun 2005 12:43:59 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 30776528D9 for ; Thu, 23 Jun 2005 09:43:56 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id C63C23095A; Thu, 23 Jun 2005 14:45:22 +0200 (MET DST) From: orange_crush_068@hotmail.com X-Newsgroups: pgsql.sql Subject: Unique primary index? Date: 23 Jun 2005 05:43:52 -0700 Organization: http://groups.google.com Lines: 7 Message-ID: <1119530632.181638.4330@g49g2000cwa.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: g49g2000cwa.googlegroups.com; posting-host=210.84.135.136; posting-account=ErRm3Q0AAADWTYoG-NwODCDnxGuR74HS To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.134 tagged_above=0 required=5 tests=FORGED_HOTMAIL_RCVD2, FROM_ENDS_IN_NUMS, FROM_HAS_ULINE_NUMS, NO_REAL_NAME X-Spam-Level: ** X-Archive-Number: 200506/325 X-Sequence-Number: 21926 What are the major differences between Unique, primary index & just plain index? When creating tables I nominate one of these, but not sure what the difference is?