Walt Bigelow <walt@stimpy.com> writes:
> On Tue, 13 Apr 1999, Tom Lane wrote:
>>>> This query returns 0 rows [ when it shouldn't ].
> The output of explain:
> NOTICE: QUERY PLAN:
> Seq Scan on tbladdress (cost=50.34 size=348 width=24)
> SubPlan
> -> Unique (cost=50.34 size=0 width=0)
> -> Sort (cost=50.34 size=0 width=0)
> -> Seq Scan on tbladdress (cost=50.34 size=348 width=4)
That looks about like what I'd expect (although I suppose you left
off the ORDER BY clause when doing the EXPLAIN? With it, there should
be a top-level Sort node).
I'm not able to duplicate your problem here on a toy table, using either
6.4.2 or 6.5-current. Perhaps there is some platform dependency
involved. Can anyone else try it?
regards, tom lane