Very observant of you. The postgres function system doesn't have a way
to tell which parameter is null, so the function just returns null.
I don't like it and we hope to get it changed for PGv6.5 (at least I
do).
Is it on the TODO guys? Jan, do you think you'll have the time to get
to it by bet
I wrote a c func (ATTACHED BELOW) which takes 2 pointers to type text, and
a bool field. When a field in a row passed to the func is null, espically
the 'first' field, Postgresql does not return the value that my code
produced.
For example:
First lastco nocompany
---