Re: PG not rejecting bad dates (was Re: Finding bogus

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: David Fetter <david(at)fetter(dot)org>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: PG not rejecting bad dates (was Re: Finding bogus
Date: 2007-01-19 15:08:39
Message-ID: C1D62D07.60654%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> That would explain everything. Except why it's a VARCHAR instead of
>> DATE. But that's a whole 'nother discussion.
>
> As I understood OP, it's a staging table :)

Right. And it's exactly because the original source has bogus data that I
need a staging table to load it up and study it and fix it.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2007-01-19 15:41:49 Re: Password encryption method
Previous Message Darcy Buskermolen 2007-01-19 14:48:26 Re: [HACKERS] Autovacuum Improvements