Re: CAST(null as date)...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ian Harding" <ianh(at)tpchd(dot)org>
Cc: sszabo(at)megazone23(dot)bigpanda(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: CAST(null as date)...
Date: 2002-06-19 12:57:24
Message-ID: 3540.1024491444@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2002-06-19 13:15:54 Re: rules in other languages
Previous Message Neal Holtz 2002-06-19 12:46:21 Quoted identifiers in queries in plpgsql functions.