Re: Null comparisons and the transform_null_equals run-time parameter

Steve ~

Thanks for the great tips.  See comments below.

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Steve Atkins
> Sent: Saturday, June 05, 2010 1:04 PM
> To: PostgreSQL pg-general List
> Subject: Re: [GENERAL] Null comparisons and the transform_null_equals run-
> time parameter
>
>
> On Jun 5, 2010, at 9:46 AM, Ken Winter wrote:

> > 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".

Wow, that's the same wheel I just reinvented!  Works fine in my test
functions.  Guess I can scrap my home-brewed functions that do the same
thing.

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

Yes indeed, looks very promising.

I see there are also test frameworks available at
http://en.dklab.ru/lib/dklab_pgunit/ and http://www.epictest.org/ .

This will take me a while to digest, but hopefully I'll be able to scrap, or
greatly simplify, my elaborate homemade test functions too.  It's always a
joy to be able to replace my own code with somebody else's.

~ Ken