Re: Single row tables

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