Re: Null comparisons and the transform_null_equals run-time parameter
От | Ken Winter |
---|---|
Тема | Re: Null comparisons and the transform_null_equals run-time parameter |
Дата | |
Msg-id | 814C6BD07B4A4B2FA3E4F72CE6A12BF4@KenIBM обсуждение исходный текст |
Ответ на | Re: Null comparisons and the transform_null_equals run-time parameter (Steve Atkins <steve@blighty.com>) |
Ответы |
Dell Poweredge server and Postgres
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: