Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Selecting newly added column returns empty but only when selecting with other columns in table
Date
Msg-id CAKFQuwZbs8-0_Hd4GAah4ysMxVRB5fifV14pR5rESYa8ATxgag@mail.gmail.com
Whole thread Raw
In response to Re: Selecting newly added column returns empty but only when selecting with other columns in table  (mrtruji <mrtruji@gmail.com>)
Responses Re: Selecting newly added column returns empty but only when selecting with other columns in table
List pgsql-general
Tree view
On Thursday, November 26, 2015, mrtruji <mrtruji@gmail.com> 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)


 Please bottom post.

What do you get with explain analyze on those two queries.

David J.

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Selecting newly added column returns empty but only when selecting with other columns in table
Next
From: "David G. Johnston"
Date:
Subject: Re: Selecting newly added column returns empty but only when selecting with other columns in table