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