Re: SELECT fails to present result rows depending on the columns to show

Ilya Anfimov schrieb am 23.11.2021 um 09:31:
>> but:
>>
>> sisis=# select * from titel_worte where desk = '2' and feldnr = 257;
>> desknr | feldnr | desk | deskorg | gesanz | aufanz | katkey1 | katkey2
>> --------+--------+------+---------+--------+--------+---------+---------
>> (0 row)
>>
>> sisis=# select desk, feldnr, deskorg from titel_worte where desk = '2' and feldnr = 257;
>> desk | feldnr | deskorg
>> ------+--------+---------
>> (0 row)
>>
>> The table was created as:
>>
>> create table titel_worte (
>> desknr serial ,
>> feldnr SMALLINT ,
>> desk VARCHAR (245) ,
>> deskorg VARCHAR (245) ,
>> gesanz INTEGER ,
>> aufanz INTEGER ,
>> katkey1 INTEGER ,
>> katkey2 INTEGER
>> )
>> ;
>>
>> There are no messages in the serverlog when the SELECT fails to show the
>> row.
>>
>> What could be the reason for this? Thanks
>
> Broken index could. Then this anomaly shoud have gone after reindex table.

Ilya refers to the problems decribed here:

https://wiki.postgresql.org/wiki/Locale_data_changes