Re: The empty list?

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: "Jesper Krogh" <jesper(at)krogh(dot)cc>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: The empty list?
Date: 2006-11-03 18:26:33
Message-ID: bf05e51c0611031026m1ec5da99wc00fa25e27bde911@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 11/3/06, Jesper Krogh <jesper(at)krogh(dot)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
==================================================================

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Frost 2006-11-03 18:36:41 Re: delete and select with IN clause issues
Previous Message Aaron Bono 2006-11-03 18:04:54 Re: Determining correct table order for insert or drop statements to satisfy foreign keys