Re: [SQL] check data for datatype

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>, Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] check data for datatype
Date: 2015-04-07 21:31:35
Message-ID: 55244CB7.50901@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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 Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-04-07 21:35:03 Re: Problems with casting
Previous Message Jim Nasby 2015-04-07 21:27:46 Re: Problems with casting

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2015-04-07 21:36:22 Re: Setting the Field Separator in PSQL
Previous Message Osborn, Marty 2015-04-07 20:39:07 Setting the Field Separator in PSQL