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... David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/selecting-for-type-cast-failures-tp5747875p5747890.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general