Greetings!
I would like to be able to update certain columns based on their value. I
was looking at "ON CONFLICT", but I could not understand it nor I could not
find any examples quickly, so I say, "heck, that's what the list is for..."
:-)
What I would like is to do something like this,
UPDATE table SET
ID = '88' if not = '88',
parent = '1171291314642' if null,
children = '',
login = 'blah',
notes = 'blah-blah' if null,
status = 'o'
WHERE ProjID = '88';
Will anyone feel the love today and tell me if this is possible? Or just a
simple example will be the deed of the day.
thanks,
josé
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------