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 | 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 matthias -- Matthias Apitz, ✉ guru@xxxxxxxxxxx, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub
