Re: CAST(null as date)...

Argh! I have a dog-eared copy of that page of the docs that I printed on 5/11/01. Time to print a new one!!

Thanks!

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding(at)tpchd(dot)org

We have only two things to worry about: That things will never get
back to normal, and that they already have.

>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 06/19/02 05:57AM >>>
"Ian Harding" <ianh(at)tpchd(dot)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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly