[Info-Ingres] Ingres UPDATE statement

[Roy Hann]

"Paul" <paullingard at hotmail.co.uk> wrote in message 
news:1174298849.511345.286700 at y80g2000hsf.googlegroups.com...
> Does anyone know how to limit the number of rows affected by an UPDATE
> statement?

Use a WHERE clause in the usual way:

UPDATE foo
SET bar=...
WHERE some-condition-is-true

Or do I misunderstand what the problem is?  (For instance I could imagine 
you might want to update rows where the condition is true AND the update 
actually changes something.)

Roy