X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id D43FAD1DC1E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  6 Apr 2004 12:18:42 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 87813-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  6 Apr 2004 12:18:37 -0300 (ADT)
Received: from tht.net (vista.tht.net [216.126.88.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 3325FD1ED12
	for <pgsql-sql@postgresql.org>; Tue,  6 Apr 2004 12:18:37 -0300 (ADT)
Received: from [134.22.71.250] (dyn-71-250.tor.dsl.tht.net [134.22.71.250])
	by tht.net (Postfix) with ESMTP
	id EA53A76AEB; Tue,  6 Apr 2004 11:18:34 -0400 (EDT)
Subject: Re: partial unique constraint
From: Rod Taylor <rbt@rbt.ca>
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <1081261772.31785.48.camel@camel>
References: <1081261772.31785.48.camel@camel>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-49LQ976WpxrLlw66GZRv"
Message-Id: <1081264668.56361.531.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Tue, 06 Apr 2004 11:17:49 -0400
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200404/42
X-Sequence-Number: 17417

--=-49LQ976WpxrLlw66GZRv
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Tue, 2004-04-06 at 10:29, Robert Treat wrote:
> Trying to come up with the proper syntax to meet the following criteria:
>=20
> create table foo (bar integer, baz boolean UNIQUE (bar, baz =3D true));=
=20

Tt takes 2 steps.

CREATE TABLE ...
CREATE UNIQUE INDEX ... (bar) WHERE baz =3D true;

--=20
Rod Taylor <rbt [at] rbt [dot] ca>

Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
PGP Key: http://www.rbt.ca/signature.asc

--=-49LQ976WpxrLlw66GZRv
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)

iD8DBQBAcsoc6DETLow6vwwRAqnAAJ9dvwFDW//s2gnHHczeO+nG7Y4gkwCdHWnz
TBFFNpTJhh9WITpwIUSGfig=
=EB0y
-----END PGP SIGNATURE-----

--=-49LQ976WpxrLlw66GZRv--