Postgres Pro
Downloads
Home   >   mailing lists

order of multiple assignments in UPDATE - Mailing list pgsql-sql

From Anuradha Ratnaweera
Subject order of multiple assignments in UPDATE
Date
Msg-id Pine.LNX.4.21.0104281846010.233-100000@presario
Whole thread Raw
In response to simulate union in subselect  ("Wei Weng" <wweng@kencast.com>)
List pgsql-sql
Tree view 
If I have a query
 UPDATE tablename SET c1 = 10 - c2, c2 = 4 where ...

will the two assignments be evaluated from left to right?

Thanks in advance.

Anuradha

pgsql-sql by date:

Previous
From: Steve Meynell
Date:
Subject: Heres a good one...
Next
From: Anuradha Ratnaweera
Date:
Subject: Re: Heres a good one...