On 4/7/15 11:59 AM, Gerardo Herzig wrote:
I guess that could need something like (untested)
delete from bigtable text_column !~ '^[0-9][0-9]*$';
Won't work for...
.1
-1
1.1e+5
...
Really you need to do something like what Jerry suggested if you want
this to be robust.
--
Jim Nasby, Data Ar
I guess that could need something like (untested)
delete from bigtable text_column !~ '^[0-9][0-9]*$';
HTH
Gerardo
- Mensaje original -
> De: "Suresh Raja"
> Para: pgsql-general@postgresql.org, pgsql-...@postgresql.org
> Enviados: Viernes, 27 de Marzo 2015 15:08:43
> Asunto: [SQL] chec
