Received: from localhost (uranus.hub.org [200.46.204.60])
	by postgresql.org (Postfix) with ESMTP id 56D9A9FB2A6
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  3 Nov 2006 14:26:41 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024)
	with ESMTP id 86988-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  3 Nov 2006 14:26:35 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175])
	by postgresql.org (Postfix) with ESMTP id 0D1CD9FB299
	for <pgsql-sql@postgresql.org>; Fri,  3 Nov 2006 14:26:34 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id q2so432884uge
	for <pgsql-sql@postgresql.org>; Fri, 03 Nov 2006 10:26:34 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	b=aPp8uOvdQcrgCU9i7qd44nZLd6OsTRCSLIDwS9x7yHb4XuJmteSaw8O6YJxEZvot56/wO4+NdnFtTkHIZN7D0fdS6q3sBOk1DCdnB+XJ0zQquqSmdgQENVb/cWB0MJdVhs3zudYL3t/Tif+6C7WhuJdZnQ+WwBNFd5B9Ob+so/U=
Received: by 10.78.172.20 with SMTP id u20mr3303822hue.1162578393471;
	Fri, 03 Nov 2006 10:26:33 -0800 (PST)
Received: by 10.78.136.6 with HTTP; Fri, 3 Nov 2006 10:26:33 -0800 (PST)
Message-ID: <bf05e51c0611031026m1ec5da99wc00fa25e27bde911@mail.gmail.com>
Date: Fri, 3 Nov 2006 12:26:33 -0600
From: "Aaron Bono" <postgresql@aranya.com>
To: "Jesper Krogh" <jesper@krogh.cc>
Subject: Re: The empty list?
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, pgsql-sql@postgresql.org
In-Reply-To: <454ADB6F.9070602@krogh.cc>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_17247_20427823.1162578393429"
References: <454A654B.2000306@krogh.cc> <21991.1162506863@sss.pgh.pa.us>
	<bf05e51c0611021443q27b1012bt9236ca595e1f03c2@mail.gmail.com>
	<454ADB6F.9070602@krogh.cc>
X-Google-Sender-Auth: 2e7443e942608ae6
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/41
X-Sequence-Number: 26693

------=_Part_17247_20427823.1162578393429
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.com
   http://codeelixir.com
==================================================================

------=_Part_17247_20427823.1162578393429
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 11/3/06, <b class="gmail_sendername">Jesper Krogh</b> &lt;<a href="mailto:jesper@krogh.cc">jesper@krogh.cc</a>&gt; wrote:<div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
... but missing SQL for the empty list basically means that<br>we cant handle the empty set encoded in the empty array without<br>explicitly introducing code for this size of array. From a<br>programatically viewpoint, this seems quite odd.
<br></blockquote></div><br>Somebody, somewhere has to programitacally handle the empty array.&nbsp; You are just suggesting that the database do it, not you.<br><br>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.&nbsp; The additional checks in your code can help reduce database calls and increase performance.
<br clear="all"><br>-- <br>==================================================================<br>&nbsp;&nbsp; Aaron Bono<br>&nbsp;&nbsp; Aranya Software Technologies, Inc.<br>&nbsp;&nbsp; <a href="http://www.aranya.com">http://www.aranya.com</a><br>&nbsp;&nbsp; 
<a href="http://codeelixir.com">http://codeelixir.com</a><br>==================================================================

------=_Part_17247_20427823.1162578393429--