UPDATE statement

From: Geoffrey KRETZ <gk(at)4js(dot)com>
To: pgsql-general(at)PostgreSQL(dot)org
Subject: UPDATE statement
Date: 2004-07-19 08:45:44
Message-ID: 40FB8A38.3000603@4js.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Is it a way to make the following UPDATE statement work with PGS 7.4
(UNIX) :

UPDATE dbit2 SET (dbit2_key,dbit2_c10,dbit2_vc200) = (ABS(-1),NULL,'xx')
WHERE dbit2_key=1

Or am I force to use the following syntax :

UPDATE dbit2 SET dbit2_key = ABS(-1), dbit2_c10 = NULL , dbit2_vc200 =
'xx' WHERE dbit2_key=1

Geoffrey KRETZ - Four J's Development Tools

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey KRETZ 2004-07-19 09:27:25 Re: Question on INSERT statement
Previous Message Geoffrey KRETZ 2004-07-19 07:53:45 Question on INSERT statement