Re: The empty list?

Поиск
Список
Период
Сортировка
От Aaron Bono
Тема Re: The empty list?
Дата
Msg-id bf05e51c0611031026m1ec5da99wc00fa25e27bde911@mail.gmail.com
обсуждение исходный текст
Ответ на Re: The empty list?  (Jesper Krogh <jesper@krogh.cc>)
Список 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 по дате отправления:

Предыдущее
От: "Aaron Bono"
Дата:
Сообщение: Re: Determining correct table order for insert or drop statements to satisfy foreign keys
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: delete and select with IN clause issues