Look like another case of PEBKAC solved. Thanks Adrian & JOhn for the assist. Happy Thanksgiving everyone.
On Thu, Nov 26, 2015 at 10:22 PM, John R Pierce <pie...@hogranch.com> wrote: > On 11/26/2015 7:08 PM, mrtruji wrote: > >> Ok this is strange. Shouldn't it always be one or the other? Total row >> count for the table is 279,096. >> >> doggies=# select count(*) from data where features_bin is null; >> count >> -------- >> 279096 >> (1 row) >> >> doggies=# select count(*) from data where features_bin is not null; >> count >> -------- >> 279096 >> (1 row) >> > > > you inserted 278096 additional rows with (NULL, NULL, <somevalues>) to the > 279096 existing rows that had (value,value,NULL) > > > > > > > -- > john r pierce, recycling bits in santa cruz > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
