On Tue, Jul 19, 2011 at 10:41 PM, <tomas@xxxxxxxxxx> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Mon, Jul 18, 2011 at 03:18:43PM -0700, Shianmiin wrote: >> setup: >> ==== >> drop table if exists t1; >> create table t1 (f1 int); >> create unique index uix_t1 on t1(f1) ; >> insert into t1(f1) values (1), (2), (3); >> select * from t1; >> >> f1 If you are trying to make this work, you can add an order by to the update and that allows you to avoid this problem. Best Wishes, Chris Travers -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general