DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=ZdOkvsTt0+njGyfOld6uqizUVC0ziEBU1K/W7Jyf26TVt6ZbYrkTvFpFzbpNpVGImtG63/+3iA20/WqVaP+8Eh27+ww253kTeR3CtCqMcHbJweXozG4FmoF4EJc7ybEi7VtXBx2BYdrZweLRyZf49FvluXttVd/Zbv87kzv6IvU=
	;
Message-ID: <20051026180632.62456.qmail@web54301.mail.yahoo.com>
Date: Wed, 26 Oct 2005 11:06:32 -0700 (PDT)
From: chester c young <chestercyoung@yahoo.com>
Subject: Re: broken join optimization? (8.0) 
To: pgsql-sql@postgresql.org
In-Reply-To: <7220.1130344752@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

> Tom Lane <tgl@sss.pgh.pa.us> wrote:

> 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?
> 

with a form that is used for CRUD, values are filled in from a record
(either an object or array).  when creating, you want an empty record
so that form.item values are set to null.  makes for much easier
programming and ensures all variables are defined.

retrieving the metadata and then creating the record seems like a lot
of work when the whole thing can be done with one select (which would
needed in any case to get the metadata).


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com