order of multiple assignments in UPDATE

From: Anuradha Ratnaweera <anuradha(at)gnu(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: order of multiple assignments in UPDATE
Date: 2001-04-28 12:48:49
Message-ID: Pine.LNX.4.21.0104281846010.233-100000@presario
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Anuradha Ratnaweera 2001-04-28 13:10:23 Re: Heres a good one...
Previous Message Steve Meynell 2001-04-27 19:16:26 Heres a good one...