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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
