content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: Re: Single row tables
Date: Tue, 11 Jan 2005 09:50:11 -0500
Message-ID: 
 <7A4ADADFC8AFF0478D47F63BEDD57CE33A339A@gpmail.gphq.genpathpharma.com>
Thread-Topic: [SQL] Single row tables
Thread-Index: AcT37F7Bq3TD/F32R42gTHr2q6BHkQAAEdFQ
From: "Dmitri Bichko" <dbichko@genpathpharma.com>
To: =?iso-8859-1?Q?K=D6PFERL_Robert?= <robert.koepferl@sonorys.at>
Cc: <pgsql-sql@postgresql.org>

I suppose you could put a check constraint that forces a single value on =
a column with a unique index?  Or an insert trigger that always inserts =
the same value into a unique field.

Out of curiosity, why do you need to do this?

Dmitri

-----Original Message-----
From: pgsql-sql-owner@postgresql.org =
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of K=D6PFERL Robert
Sent: Tuesday, January 11, 2005 9:46 AM
Cc: pgsql-sql@postgresql.org
Subject: [SQL] Single row tables
Importance: High


Hi,

with what constraint or how can I ensure that one of my tables has exact =
one record or 0..1 records?

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings