On 8 Jun 2009, at 17:23, Merlin Moncure <mmoncure@xxxxxxxxx> 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)); 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@xxxxxxxxxx / 0845 456 1810 / 07814 828608 www.gtwm.co.uk - company www.gtportalbase.com - product |
