> NOT EXISTS (SELECT NULL FROM dyr_pause_mot WHERE avlsnr = a.avlsnr)
>
> This can be executed as anti-join and is often more efficient.
This got my interest! It's of great interest to me to know how and when Postgres performs an anti-join (this being a
significantomission from SQL).
Is this a reliable trigger: (NOT EXISTS <subselect>)?
Regards
David M Bennett FACS
Andl - A New Database Language - andl.org