Re: The same result for with SPACE and without SPACE

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: The same result for with SPACE and without SPACE
Дата
Msg-id CAKFQuwazHio_fz1ZKO9WSw5Q6hD9BVJJmf_Lbk06R2uduswUQg@mail.gmail.com
обсуждение исходный текст
Ответ на The same result for with SPACE and without SPACE  (M Sarwar <sarwarmd02@outlook.com>)
Список pgsql-advocacy
Дерево обсуждения
As noted on this page, the -general list is a much more appropriate place to send this question.  Advocacy, not even close.
https://www.postgresql.org/list/

On Wed, Jun 14, 2023 at 2:08 PM M Sarwar <sarwarmd02@outlook.com> wrote:

Please note in SQL-1 that test_number = 'TEST4P20 ' has a space and in SQL-2 there is no space test_number = 'TEST4P20' has no space.

Is it not a bug?

Doubtful.  You haven't provided actual data types here but it seems you are using character instead of text.  Your desired behavior is provided by the text data type.

David J.

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

Предыдущее
От: M Sarwar
Дата:
Сообщение: The same result for with SPACE and without SPACE
Следующее
От: Jacob Champion
Дата:
Сообщение: Timescale's State of PostgreSQL 2023 Survey