On Thu, Nov 26, 2015 at 7:24 PM, Melvin Davidson <melvin6...@gmail.com> wrote:
> 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. > Thanks for all the responses and for pointing me in the right direction!
