zero char is returned as space

Поиск
Список
Период
Сортировка
От Konstantin Izmailov
Тема zero char is returned as space
Дата
Msg-id CAAw-Mse09yrTd=XKWY=k1ru_HvpQwBHa7PkubkbS3wJndFxxgw@mail.gmail.com
обсуждение исходный текст
Ответы Re: zero char is returned as space
Список pgsql-hackers
Hi,
could you help me understand if this is an intended behaviour, or I'm incorrectly querying a "char" field? I have simple table with column declared as:
  c_tinyint char NOT NULL

The column contains tiny integers in range 0-10. When I query the column from my app using libpq values 1-10 are returned correctly as 0x1-0x10. But value of zero is returned as 0x20 (expected 0x0).
The pgAdmin displays result of the query
SELECT c_tinyint, ascii(c_tinyint) FROM tbl
as shown below:
| c_tinyint       | ascii     |
| character(1) | integer |
|                     |  0         |
|                     |  1         |
|                     |  2         |
|                     |  3         |
|                     |  4         |

Thank you
K

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Logical replication row filtering and TOAST
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: pg_walinspect - a new extension to get raw WAL data and WAL stats