Re: selecting for type cast failures - Mailing list pgsql-general

From Adrian Klaver
Subject Re: selecting for type cast failures
Date
Msg-id 513CD64E.3050401@gmail.com
Whole thread Raw
In response to Re: selecting for type cast failures  (David Johnston <polobo@yahoo.com>)
List pgsql-general
On 03/07/2013 08:56 PM, David Johnston wrote:
> Adrian Klaver-3 wrote
>> My opinion, it would take more time to concoct regexes that cover all
>> the corner cases than to write a script that walks the through the data
>> , finds the problem data and flags them.
>
> ISTM that using regular expressions is necessary regardless of whether you
> put them into a function/script or otherwise use them interactively via
> queries...

Not necessarily. I have done this sort of thing in Python by 'pre'
casting, using Python casting to weed out the problem children.

>
> David J.
>
>
>
>
>

--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: table spaces
Next
From: Csanyi Pal
Date:
Subject: ERROR: relation "employees" does not exist