On 2/13/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
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';
Well, if you UPDATE table SET ID = '88' WHERE ProjID = '88' it will set it to 88 whether or not it is 88. Problem solved. Also UPDATE table SET parent = '1171291314642' WHERE ProjID = '88' AND parent IS NULL will do the appropriate thing only if parent is null. Else, it will leave it alone. In any case, WHERE clause is the correct place to put your constraints, not the SET clause, unless you write functions that return the desired value to be SET. -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------