On 27/03/2015 18:08, Suresh Raja wrote:
> Hi All:
>
>
> I have a very large table and the column type is text. I would like to
> convert in numeric. How can I find rows that dont have numbers. I
> would like to delete those rows.
Use a regular expression:
select <whatever> from <the table> where <the column> ~ <regexp>
http://www.postgresql.org/docs/9.4/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
