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