Re: selecting for type cast failures

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: selecting for type cast failures
Дата
Msg-id 513CD64E.3050401@gmail.com
обсуждение исходный текст
Ответ на Re: selecting for type cast failures  (David Johnston <polobo@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: table spaces
Следующее
От: Csanyi Pal
Дата:
Сообщение: ERROR: relation "employees" does not exist