> -----Original Message----- > From: Andrew Dunstan [mailto:and...@dunslane.net] > Sent: Tuesday, June 22, 2010 7:47 PM > To: Francis Markham > Cc: Dann Corbit; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] 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.
For the O.P.: This is the specification of the input format that is needed for date/time values: http://www.postgresql.org/docs/8.4/interactive/datatype-datetime.html See also: http://www.postgresql.org/docs/8.4/interactive/datetime-appendix.html If he wants to be able to simply validate date/time values before insertion, I would suggest a package like libmcal and pick out the file datetime.c, in particular: extern bool datevalid(int year,int mon,int mday); extern bool timevalid(int hour,int min,int sec); The PostgreSQL database routine has lots of fluff intended for interfacing with the database, etc. which makes a simpler approach easier if validation is what is wanted. Of course date/time/calendar libraries are available in just about every language. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
