Re: broken join optimization? (8.0) - Mailing list pgsql-sql

From Tom Lane
Subject Re: broken join optimization? (8.0)
Date
Msg-id 7220.1130344752@sss.pgh.pa.us
Whole thread Raw
In response to Re: broken join optimization? (8.0)  (chester c young <chestercyoung@yahoo.com>)
Responses Re: broken join optimization? (8.0)  (chester c young <chestercyoung@yahoo.com>)
List pgsql-sql
chester c young <chestercyoung@yahoo.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


pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: why vacuum
Next
From: Tyler Kellen
Date:
Subject: SUM not matching up on a JOIN