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
Список
Дерево обсуждения
SELECT fails to present result rows depending on the columns to show Matthias Apitz <guru@unixarea.de>
Re: SELECT fails to present result rows depending on the columns to show Ilya Anfimov <ilan@tzirechnoy.com>
Re: SELECT fails to present result rows depending on the columns to show Thomas Kellerer <shammat@gmx.net>
Re: SELECT fails to present result rows depending on the columns to show Matthias Apitz <guru@unixarea.de>

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
Дата:
От: Ilya Anfimov
Дата:
FAQ