Suresh Raja writes:
> 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.
begin;
set local client_min_messages to notice;
create table foo (a text
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 from where ~
http:
>
> 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
