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])