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

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

Responses

Browse pgsql-general by date

  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