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