From: | Matthias Apitz <guru(at)unixarea(dot)de> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | SELECT fails to present result rows depending on the columns to show |
Date: | 2021-11-23 08:15:06 |
Message-ID: | YZyjCkcCloug4Xun@c720-r368166 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
From | Date | Subject | |
---|---|---|---|
Next Message | Ilya Anfimov | 2021-11-23 08:31:21 | Re: SELECT fails to present result rows depending on the columns to show |
Previous Message | James Sewell | 2021-11-23 06:08:59 | Max connections reached without max connections reached |