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