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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to