Re: CAST(null as date)... - Mailing list pgsql-general

From Ian Harding
Subject Re: CAST(null as date)...
Date
Msg-id sd104cff.048@mail.tpchd.org
Whole thread Raw
In response to CAST(null as date)...  ("Ian Harding" <ianh@tpchd.org>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Lee Kindness
Date:
Subject: Re: database size
Next
From: Masaru Sugawara
Date:
Subject: Re: Quoted identifiers in queries in plpgsql functions.