Re: [pgsql-general] Daily digest v1.9081 (14 messages) - Mailing list pgsql-general

From Oliver Kohll - Mailing Lists
Subject Re: [pgsql-general] Daily digest v1.9081 (14 messages)
Date
Msg-id 1E5E0C2C-DEB8-41FD-AAF9-D98B87BC382B@gtwm.co.uk
Whole thread Raw
Responses Re: [pgsql-general] Daily digest v1.9081 (14 messages)
List pgsql-general
On 8 Jun 2009, at 17:23, Merlin Moncure <mmoncure@gmail.com> 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

To clever for me, I don't understand what's going on and can't replicate it in my 8.3. Any expansion?

Rgs
Oliver

oliver@gtwm.co.uk / 0845 456 1810 / 07814 828608
www.gtwm.co.uk - company

pgsql-general by date:

Previous
From: Oliver Kohll - Mailing Lists
Date:
Subject: Re: Sum of multiplied deltas
Next
From: Keaton Adams
Date:
Subject: Re: Any way to bring up a PG instance with corrupted data in it?