Re: How to use read uncommitted transaction level and set update order

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Christophe Pettus" <xof(at)thebuild(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to use read uncommitted transaction level and set update order
Date: 2009-12-19 23:34:35
Message-ID: F1E1EFEE34194DAB98858CB65B654DE3@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I would be quite surprised if there are any SQL databases that do this
> differently.

FoxPro's and probably dBase's do it differently.

CREATE CURSOR t ( a i, b i )
INSERT INTO t VALUES (1,2)
UPDATE t SET a=3, b=a
SELECT * FROM t

returns 3 for b

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2009-12-20 00:06:03 Re: How to use read uncommitted transaction level and set update order
Previous Message Andrus 2009-12-19 23:05:55 How to find string intersection