I guess that could need something like (untested) delete from bigtable text_column !~ '^[0-9][0-9]*$';
HTH Gerardo ----- Mensaje original ----- > De: "Suresh Raja" <[email protected]> > Para: [email protected], [email protected] > 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
