maybe: where (float(ctxt(doublecolumn)) is null and doublecolumn is not null
? On Fri, Feb 13, 2015 at 12:37 PM, jan johansen <[email protected]> wrote: > Group, > > Because the most recent update really needs your database to do a complete > unload and reload, > I've come across a couple of problems (stress these are problems with my > data). > > During the reload I receive numerous errors of ONE specific problem, > COLUMN mycolumnname must be valid DOUBLE. > > Fine. Then I search the column and fix the data and unload again. > > I've searched on that column looking for stuff like a text or something > but not really seeing a problem. > How would I query the database looking for an invalid value in that column? > > Jan >
