Hi, Back in 2002 these were proposed, what happened to them?
http://archives.postgresql.org/pgsql-sql/2002-09/msg00406.php Also I note: co...@ruby:~/workspace/eyedb$ psql psql (8.4.4) Type "help" for help. colin=> select to_date('731332', 'YYMMDD'); to_date ------------ 1974-02-01 (1 row) colin=> The fact that this wraps would seem to me to make the implementation of is_date() difficult. I'm trying to query character strings for valid dates but can't see how to do this quickly... but for that discussion I will move to pgsql-general :-) Cheers, Colin