From: Aaron Bono <postgresql@aranya.com>
To: Jesper Krogh <jesper@krogh.cc>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: The empty list?
Date: Fri, 3 Nov 2006 12:26:33 -0600
Message-ID: <bf05e51c0611031026m1ec5da99wc00fa25e27bde911@mail.gmail.com> (raw)
In-Reply-To: <454ADB6F.9070602@krogh.cc>
References: <454A654B.2000306@krogh.cc>
<21991.1162506863@sss.pgh.pa.us>
<bf05e51c0611021443q27b1012bt9236ca595e1f03c2@mail.gmail.com>
<454ADB6F.9070602@krogh.cc>
On 11/3/06, Jesper Krogh <jesper@krogh.cc> wrote:
>
> ... but missing SQL for the empty list basically means that
> we cant handle the empty set encoded in the empty array without
> explicitly introducing code for this size of array. From a
> programatically viewpoint, this seems quite odd.
>
Somebody, somewhere has to programitacally handle the empty array. You are
just suggesting that the database do it, not you.
Also, if you were selecting anything from an empty list and your program
knows it is from an empty list, why even bother asking the database. The
additional checks in your code can help reduce database calls and increase
performance.
--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.comhttp://codeelixir.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: postgresql@aranya.com, jesper@krogh.cc, tgl@sss.pgh.pa.us
Subject: Re: The empty list?
In-Reply-To: <bf05e51c0611031026m1ec5da99wc00fa25e27bde911@mail.gmail.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