I suppose you could put a check constraint that forces a single value on a column with a unique index? Or an insert
triggerthat 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ÖPFERL 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