Postgres Pro
Downloads
Home   >   mailing lists

Re: The same result for with SPACE and without SPACE - Mailing list pgsql-advocacy

From David G. Johnston
Subject Re: The same result for with SPACE and without SPACE
Date
Msg-id CAKFQuwazHio_fz1ZKO9WSw5Q6hD9BVJJmf_Lbk06R2uduswUQg@mail.gmail.com
Whole thread Raw
In response to The same result for with SPACE and without SPACE  (M Sarwar <sarwarmd02@outlook.com>)
List pgsql-advocacy
Tree view
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 by date:

Previous
From: M Sarwar
Date:
Subject: The same result for with SPACE and without SPACE
Next
From: Jacob Champion
Date:
Subject: Timescale's State of PostgreSQL 2023 Survey