Re: Null comparisons and the transform_null_equals run-time parameter

Поиск
Список
Период
Сортировка
Искать
От
Steve Atkins
Тема
Re: Null comparisons and the transform_null_equals run-time parameter
Дата
Msg-id
EE9774F2-14D8-4B5D-92F8-272315B112CA@blighty.com
Ответ на
Re: Null comparisons and the transform_null_equals run-time parameter (Ken Winter)
Список
Дерево обсуждения
Null comparisons and the transform_null_equals run-time parameter "Ken Winter" <ken@sunward.org>
Re: Null comparisons and the transform_null_equals run-time parameter Tom Lane <tgl@sss.pgh.pa.us>
Re: Null comparisons and the transform_null_equals run-time parameter "Ken Winter" <ken@sunward.org>
Re: Null comparisons and the transform_null_equals run-time parameter Tom Lane <tgl@sss.pgh.pa.us>
Re: Null comparisons and the transform_null_equals run-time parameter Steve Atkins <steve@blighty.com>
Re: Null comparisons and the transform_null_equals run-time parameter "Ken Winter" <ken@sunward.org>
Dell Poweredge server and Postgres u235sentinel <u235sentinel@gmail.com>
Re: Dell Poweredge server and Postgres John R Pierce <pierce@hogranch.com>
Re: Dell Poweredge server and Postgres u235sentinel <u235sentinel@gmail.com>
Re: Dell Poweredge server and Postgres Greg Smith <greg@2ndquadrant.com>
Re: Dell Poweredge server and Postgres u235sentinel <u235sentinel@gmail.com>
Re: Dell Poweredge server and Postgres Scott Marlowe <scott.marlowe@gmail.com>
Re: Dell Poweredge server and Postgres Vick Khera <vivek@khera.org>
Re: Dell Poweredge server and Postgres u235sentinel <u235sentinel@gmail.com>
Re: Dell Poweredge server and Postgres Vick Khera <vivek@khera.org>
Re: Dell Poweredge server and Postgres u235sentinel <u235sentinel@gmail.com>
Re: Dell Poweredge server and Postgres Scott Marlowe <scott.marlowe@gmail.com>
Re: Dell Poweredge server and Postgres u235sentinel <u235sentinel@gmail.com> 

On Jun 5, 2010, at 9:46 AM, Ken Winter wrote:

> I get it.  Thanks, Tom.
> 
> In case anybody else needs this functionality, let me offer a family of
> functions that do comparisons that treat NULL as a real value (rather than
> as "unknown").  For example:

You should take a look at "is not distinct from".

> 
> The reason I need this is that I'm writing functions to test my database
> programming (triggers, rules, etc), and these tests sometimes need to treat
> Null as just another value in doing test comparisons.

You also might find http://pgtap.org/ useful.

Cheers,
  Steve
В списке pgsql-general по дате отправления
Предыдущее
От: Alban Hertroys
Дата:
Следующее
От: Adrian Klaver
Дата:
FAQ