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 Melvin Davidson
Subject Re: Selecting newly added column returns empty but only when selecting with other columns in table
Date
Msg-id CANu8Fixw0Av7XwdGctKsmeUnAs_h=BsU0wqrahKV=2Ln_-_t1A@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  (John R Pierce <pierce@hogranch.com>)
Responses Re: Selecting newly added column returns empty but only when selecting with other columns in table  (mrtruji <mrtruji@gmail.com>)
List pgsql-general
Tree view
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@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.

pgsql-general by date:

Previous
From: John R Pierce
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