pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Walt Bigelow <walt@stimpy.com>
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] subqueries
Date: Tue, 13 Apr 1999 19:31:11 -0400
Message-ID: <463.924046271@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.3.96.990413130102.30435A-100000@alice.stimpy.com>

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



view thread (6+ messages)

Message-ID: <463.924046271@sss.pgh.pa.us>
Permalink:  ../463.924046271@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/463.924046271@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, walt@stimpy.com, pgsql-sql@hub.org
  Subject: Re: [SQL] subqueries
  In-Reply-To: <463.924046271@sss.pgh.pa.us>
  References: <Pine.LNX.3.96.990413130102.30435A-100000@alice.stimpy.com> <463.924046271@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox