On Wed, Nov 26, 2008 at 02:53:07PM +0100, Ivan Sergio Borgonovo wrote:
> case when ''=extinput then null else extinput::timestamp end
I'd tend to use nullif(extinput,'')::timestamp for this sort of thing.
It's not going to do anything much different from what you're doing, but
may end up evaluating "extinput" less which may be a good thing.
> Is there any cleaner functional way that doesn't involve prepared
> statement etc... since the whole exercise is caused by an
> null-impaired DB API (aka MySQLish).
As Tom said, maybe if you could send a larger example it would help.
In response to
pgsql-general by date
|Next:||From: Ronald Vyhmeister||Date: 2008-11-26 14:40:19|
|Subject: Problem with langage encoding|
|Previous:||From: Tom Lane||Date: 2008-11-26 14:02:01|
|Subject: Re: case when evaluating else condition anyway? |