Re: Selecting newly added column returns empty but only when selecting with other columns in table - Mailing list pgsql-general

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