Re: check data for datatype

I guess that could need something like (untested)

delete from bigtable text_column !~ '^[0-9][0-9]*$';

HTH
Gerardo

----- Mensaje original -----
> De: "Suresh Raja" <suresh(dot)rajaabc(at)gmail(dot)com>
> Para: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
> Enviados: Viernes, 27 de Marzo 2015 15:08:43
> Asunto: [SQL] check data for datatype
>
>
>
>
>
>
>
>
> 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.
>
>
> Thanks,
> -Suersh Raja