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

Reply via email to