Re: [SQL] subqueries

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