Thanks Tom I can confirm this passed in 8.4.1
Tom Lane wrote:
> Angus Miller <angus(at)spinnaker-ims(dot)com> writes:
>
>> Given the sql below shouldn't I get the 3 records back?
>>
>
> Try 8.4.1 --- I think you got bit by the semijoin ordering bugs in
> 8.4.0.
>
> regards, tom lane
>