Alan McDonald wrote:

>>Is it possible to fire an event off when the DepartmentId changes?
>>
> before update trigger
> if new.departmentid<>old.department.id then post_event blabla

OK, thanks.
Is it possible to get only some clients to register interest in only
some users, or do *all* clients have to be told whenever anyone's
department.id changes?

Richard