"Tyler, Mark" <Mark.Tyler@dsto.defence.gov.au> writes:
> What I want to do is to guarantee that the row is available for
> selection prior to sending the message.
You cannot do that with an AFTER trigger, because whatever it does
necessarily happens before your transaction commits. I suggest
rethinking your dislike of NOTIFY.
regards, tom lane