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