Search Postgresql Archives

Re: Null comparisons and the transform_null_equals run-time parameter

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Steve ~

Thanks for the great tips.  See comments below.

> -----Original Message-----
> From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-
> owner@xxxxxxxxxxxxxx] On Behalf Of Steve Atkins
> Sent: Saturday, June 05, 2010 1:04 PM
> To: PostgreSQL pg-general List
> Subject: Re:  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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux