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@tpchd.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@sss.pgh.pa.us> 06/19/02 05:57AM >>>
"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

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