From: chester c young <chestercyoung@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: broken join optimization? (8.0)
Date: Wed, 26 Oct 2005 11:06:32 -0700 (PDT)
Message-ID: <20051026180632.62456.qmail@web54301.mail.yahoo.com> (raw)
In-Reply-To: <7220.1130344752@sss.pgh.pa.us>
> 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
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chestercyoung@yahoo.com
Subject: Re: broken join optimization? (8.0)
In-Reply-To: <20051026180632.62456.qmail@web54301.mail.yahoo.com>
* 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