Postgres Pro
Downloads
Home   >   mailing lists

Re: Finding bogus dates - Mailing list pgsql-general

From Adam Rich
Subject Re: Finding bogus dates
Date
Msg-id 20070118185213.87697.qmail@web81415.mail.mud.yahoo.com
Whole thread Raw
In response to Finding bogus dates  (Scott Ribe <scott_ribe@killerbytes.com>)
List pgsql-general
Tree view
I suppose you could create a boolean function that does a cast, and catches the
execption, returning NULL. 
 
If that doesn't work, a perl stored procedure using Date::Calc and check_date() ?

 


----- Original Message ----
From: Scott Ribe <scott_ribe@killerbytes.com>
To: pgsql-general postgresql.org <pgsql-general@postgresql.org>
Sent: Thursday, January 18, 2007 12:26:03 PM
Subject: [GENERAL] Finding bogus dates

Suppose that I have a varchar column which contains dates, and some of them
are bogus, such as '1968-02-31'. Is it possible to specify a query condition
"cannot be cast to a valid date". (It's legacy data, and I'm trying to clean
it up before importing into the final schema.) There probably aren't that
many, and I can just keep hitting pg errors one row at a time until I work
through this, but...

--
Scott Ribe
scott_ribe@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

pgsql-general by date:

Previous
From: "Ole Laurisch"
Date:
Subject: Defining data directory while installing [WinXP]
Next
From: Richard Troy
Date:
Subject: Re: Spam from EnterpriseDB?