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

FromAaron Bono
SubjectRe: The empty list?
Date
Msg-id[email protected]
Whole thread Raw
In response toRe: The empty list?  (Jesper Krogh <[email protected]>)
Listpgsql-sql
On 11/3/06, Jesper Krogh <[email protected]> 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