Re: How to use read uncommitted transaction level and set update order - Mailing list pgsql-general

From Andrus
Subject Re: How to use read uncommitted transaction level and set update order
Date
Msg-id F1E1EFEE34194DAB98858CB65B654DE3@andrusnotebook
Whole thread Raw
In response to Re: How to use read uncommitted transaction level and set update order  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to use read uncommitted transaction level and set update order  (Christophe Pettus <xof@thebuild.com>)
List 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.

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: How to find string intersection
Next
From: Postgres User
Date:
Subject: Re: Selecting from table into an array var