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@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general