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 17E7114B2869 for ; Mon, 9 Aug 2004 06:42:08 -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 42897-09 for ; Mon, 9 Aug 2004 09:42:01 +0000 (GMT) Received: from mailgate.cubis.de (send.cubis.de [195.226.172.140]) by svr1.postgresql.org (Postfix) with ESMTP id C985A14B2822 for ; Mon, 9 Aug 2004 06:41:58 -0300 (ADT) Received: from mailscan-1.tuev-mitte.de (mailscan-1.tuev-mitte.de [10.0.142.44] (may be forged)) by mailgate.cubis.de (Switch-2.2.9/Switch-2.2.4) with SMTP id W79935GH00000B2C for ; Mon, 09 Aug 2004 11:41:52 +0200 Received: From mailscan-2.tuev-mitte.de ([10.0.142.43]) by mailscan-1.tuev-mitte.de (WebShield SMTP v4.5 MR1a P0803.345); id 1092044511723; Mon, 9 Aug 2004 11:41:51 +0200 Received: From sn-e0310.ek.secunet.de ([10.36.13.215]) by mailscan-2.tuev-mitte.de (WebShield SMTP v4.5 MR1a P0803.354); id 1092044511670; Mon, 9 Aug 2004 11:41:51 +0200 Received: from sn-e0310.ek.secunet.de (localhost [127.0.0.1]) by sn-e0310.ek.secunet.de (Postfix) with ESMTP id 650A857A84; Mon, 9 Aug 2004 11:41:49 +0200 (CEST) To: Michael Glaesemann Cc: pgsql-sql@postgresql.org Subject: Re: UNIQUE constraint References: <7E5F5B5E-E996-11D8-B87D-000A95C88220@myrealbox.com> From: Sascha Ziemann Date: 09 Aug 2004 11:41:49 +0200 In-Reply-To: <7E5F5B5E-E996-11D8-B87D-000A95C88220@myrealbox.com> Message-ID: Lines: 28 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/123 X-Sequence-Number: 18620 Michael Glaesemann writes: > On Aug 7, 2004, at 3:25 AM, Sascha Ziemann wrote: > > CREATE TABLE example ( > > a integer, > > b integer, > > c integer, > > UNIQUE (a, c) > > ); > > > > But it is not clean to me. Does the above example mean that the list > > of pairs must be unique > > Yes. Do you know wheather this is part of the SQL standard? I have to write an application that works on Postgresql and Oracle. Is this the same on Oracle? Sorry for asking but right now I have no access to the database to test it. cu Sascha -- secunet Security Networks AG, Im Teelbruch 116, 45219 Essen Tel: +49-2054-123-408 Fax: +49-2054-123-123 PGP: FBE2 A49B 6526 C1B4 7F10 24E4 5004 7C27 6E9A 9698