Re: The empty list? - Mailing list pgsql-sql

From Aaron Bono
Subject Re: The empty list?
Date
Msg-id bf05e51c0611031026m1ec5da99wc00fa25e27bde911@mail.gmail.com
Whole thread Raw
In response to Re: The empty list?  (Jesper Krogh <jesper@krogh.cc>)
List pgsql-sql
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
==================================================================

pgsql-sql by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: Determining correct table order for insert or drop statements to satisfy foreign keys
Next
From: Jeff Frost
Date:
Subject: Re: delete and select with IN clause issues