Re: broken join optimization? (8.0)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: chester c young <chestercyoung(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: broken join optimization? (8.0)
Date: 2005-10-26 16:39:12
Message-ID: 7220.1130344752@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

chester c young <chestercyoung(at)yahoo(dot)com> writes:
> i think i misled: the goal is to retrieve _one_ row where the value of
> each attribute is null.

Er, what for? There's no data content in that, by definition. Why not
retrieve zero rows and look at the metadata anyway?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tyler Kellen 2005-10-26 17:48:35 SUM not matching up on a JOIN
Previous Message Scott Marlowe 2005-10-26 16:18:36 Re: why vacuum