defferable update & unique

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: "postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: defferable update & unique
Date: 2003-11-19 11:14:53
Message-ID: 00e701c3ae8e$5b8ef370$0500a8c0@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

Does 7.4 support defferable updates on unique column ?

example

unique INT colum named u_test has the following values: 1, 2, 3, 4, 5

can i do update table set u_test = u_test + 1;

cheers
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Lunnon 2003-11-19 11:44:01 Re: Optimizing query
Previous Message Uros 2003-11-19 10:41:41 Optimizing query