UPDATE statement - Mailing list pgsql-general

From Geoffrey KRETZ
Subject UPDATE statement
Date
Msg-id 40FB8A38.3000603@4js.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Geoffrey KRETZ
Date:
Subject: Question on INSERT statement
Next
From: Geoffrey KRETZ
Date:
Subject: Re: Question on INSERT statement