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

Поиск
Список
Период
Сортировка
От Matthias Apitz
Тема SELECT fails to present result rows depending on the columns to show
Дата
Msg-id YZyjCkcCloug4Xun@c720-r368166
обсуждение исходный текст
Ответы Re: SELECT fails to present result rows depending on the columns to show
Список 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@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub



В списке pgsql-general по дате отправления:

Предыдущее
От: James Sewell
Дата:
Сообщение: Max connections reached without max connections reached
Следующее
От: Ilya Anfimov
Дата:
Сообщение: Re: SELECT fails to present result rows depending on the columns to show