On Sun, Jun 7, 2009 at 1:38 AM, Craig Ringer<craig@xxxxxxxxxxxxxxxxxxxxx> wrote: > Brandon Metcalf wrote: >> Is there a way when creating a table to limit it to one row? That is, >> without using a stored procedure? >> >> I searched the documentation, but didn't find anything. >> > > > CREATE TABLE x (...); > > CREATE UNIQUE INDEX x_only_one_row ON ((1)); very clever :D merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
