On Thu, Nov 26, 2015 at 7:24 PM, Melvin Davidson <melvin6925@xxxxxxxxx> 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 <pierce@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
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!
