Re: Implementation of Date/Time Input Interpretation

Francis Markham wrote:
> Thank you for your prompt reply.
>
>   
>> What is it exactly that you are trying to accomplish?
>>     
>
> I want to be able to, from my own script, determine if postgres will
> be able to interpret a string as a date or time.  If you can suggest a
> better way of accomplishing this beyond reimplementing your algorithm
> I would be happy to hear it!
>
>   

Call the appropriate input function in plpgsql and trap a data 
exception? These routines are going to be quite hard to mimic, I 
suspect. Getting postgres to do the work for you is probably a better 
way to go if you can.

cheers

andrew