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

2021-11-23 Thread Matthias Apitz
El día martes, noviembre 23, 2021 a las 10:09:36 +0100, Thomas Kellerer escribió: > > 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 > > Thanks for the pointer

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

2021-11-23 Thread Thomas Kellerer
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) >> >> sis

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

2021-11-23 Thread Ilya Anfimov
On Tue, Nov 23, 2021 at 09:15:06AM +0100, Matthias Apitz wrote: > > Hello, > > We encounter the following problem in a 13.1 server on Linux: > > sisis=# select desk, feldnr from titel_worte where desk = '2' and feldnr = > 257; > desk | feldnr > --+ > 2|257 > (1 row) > >

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

2021-11-23 Thread Matthias Apitz
Hello, We encounter the following problem in a 13.1 server on Linux: sisis=# select desk, feldnr from titel_worte where desk = '2' and feldnr = 257; desk | feldnr --+ 2|257 (1 row) but: sisis=# select * from titel_worte where desk = '2' and feldnr = 257; desknr | feldn