Update

[Tomasz Dubiel]

Hello.

Is there a simpler solution than:

  select column
  from table
  where ....
  into :TEST;
  if (TEST is distinct from VALUE) then 
    update table
    set value = :VALUE
    where ...;

to perform update only if it would change something?

Best regards.

[Mark Rotteveel]

Assuming tables in both SELECT and UPDATE are the same table, you can use:

update table
set column = :VALUE
where column is distinct from :VALUE
AND (conditions from old select where)
AND (conditions from old update where)

(and of course, prune duplicate conditions)
--
Mark Rotteveel

[Tomasz Tyrakowski]

Is the obvious solution:

UPDATE table
set value = :VALUE
where ... and value is distinct from :VALUE;

not feasible for some reason in your scenario?

regards
Tomasz

[Tomasz Dubiel]

Yeah, sorry and thanks. Silly question :-D