Re: Selecting newly added column returns empty but only when selecting with other columns in table

On Thu, Nov 26, 2015 at 7:24 PM, Melvin Davidson <melvin6925(at)gmail(dot)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 <pierce(at)hogranch(dot)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(at)postgresql(dot)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!