Re: [GENERAL] check data for datatype
От
Jim Nasby
Тема
Re: [GENERAL] check data for datatype
Дата
Msg-id
55244CB7.50901@BlueTreble.com
Ответ на
Re: [SQL] check data for datatype (Gerardo Herzig)
Список
Дерево обсуждения
check data for datatype Suresh Raja <suresh.rajaabc@gmail.com>
Re: check data for datatype Gerardo Herzig <gherzig@fmed.uba.ar>
Re: [GENERAL] check data for datatype Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [GENERAL] check data for datatype Raymond O'Donnell <rod@iol.ie>
Re: [GENERAL] check data for datatype Jerry Sievers <gsievers19@comcast.net>
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
В списке pgsql-sql по дате отправления
