Re: Datetime conversion in WHERE clause - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Datetime conversion in WHERE clause
Date
Msg-id 200409091142.41872.josh@agliodbs.com
Whole thread Raw
In response to Datetime conversion in WHERE clause  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List pgsql-sql
Philippe,

> Is there a way to force the date conversion to fail sliently, and simply
> return a null in case the parameter is not a valid date?

You'd need to write a custom function, using an external language that allows 
you to test for valid date values.   I prefer using PL/perlU with 
Date::Manip, but use what you like.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: aggregate function stddev
Next
From: Josh Berkus
Date:
Subject: Re: Isnumeric function?