On 7/22/09 4:39 PM, Tom Lane wrote:
> "Benjamin Reed" <ranger@opennms.org> writes:
>> I've hit a regression vs. PostgreSQL 8.2 and 8.3 (and probably others)
>> related to subselects. This query:
>
> It's not going to be possible to examine this with just the query.
> You need to provide a self-contained test case.
Attached is a test case, including the query that causes the error at
the end. On 8.3, it returns 1 row (192.168.1.1), on 8.4 including the
git 8.4 branch, it returns none.
--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/