check data for datatype

From: Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: check data for datatype
Date: 2015-03-27 18:08:43
Message-ID: CAJP7dtA8eerfd0KvAvNBd3806BQ6uwr2jYEcwgAbXJM_bDs5AQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

>
> 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eli Murray 2015-03-27 18:12:52 Re: Building JSON objects
Previous Message Day, David 2015-03-27 18:01:29 Re: segmentation fault postgres 9.3.5 core dump perlu related ?

Browse pgsql-sql by date

  From Date Subject
Next Message Raymond O'Donnell 2015-03-27 18:14:50 Re: check data for datatype
Previous Message Igor Neyman 2015-03-20 17:33:22 Re: 'bitwise and' index