Re: CAST(null as date)...

"Ian Harding" <ianh@tpchd.org> writes:
> creat function nullifzls(text) returns text as '
> if {[string length $1] == 0} {
>     return NULL
> } else {
>     return $1
> }
> ' language 'pltcl';

Try return_null

            regards, tom lane