Hi Adam,
Would this work?
UPDATE bugs SET somefield=somefield WHERE pkey='3';
i.e. set a field to itself. I don't know whether or not this would be
optimised away - but it could be worth a try.
Hope this helps.
Francis Solomon
>
> What is a good way to trigger an UPDATE of a row
> without actually
> changing anything? I have a trigger that will update the timestamp
> of a record, and in this case, want to trigger it because I am
> adding a related row in another table.
>
> UPDATE bugs WHERE pkey='3'
>
> Doesn't seem to work.