Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: CAST(null as date)...
Date
Msg-id 3540.1024491444@sss.pgh.pa.us
Whole thread Raw
In response to Re: CAST(null as date)...  ("Ian Harding" <ianh@tpchd.org>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Neal Holtz
Date:
Subject: Quoted identifiers in queries in plpgsql functions.
Next
From: Jan Wieck
Date:
Subject: Re: rules in other languages