MIME-Version: 1.0
References: 
 <DM4PR19MB5978EB964FA1C7B55FFCB02DD35AA@DM4PR19MB5978.namprd19.prod.outlook.com>
In-Reply-To: 
 <DM4PR19MB5978EB964FA1C7B55FFCB02DD35AA@DM4PR19MB5978.namprd19.prod.outlook.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 14 Jun 2023 14:19:53 -0700
Message-ID: 
 <CAKFQuwazHio_fz1ZKO9WSw5Q6hD9BVJJmf_Lbk06R2uduswUQg@mail.gmail.com>
Subject: Re: The same result for with SPACE and without SPACE
To: M Sarwar <sarwarmd02@outlook.com>
Cc: "pgsql-advocacy@postgresql.org" <pgsql-advocacy@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000053748c05fe1d8434"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwazHio_fz1ZKO9WSw5Q6hD9BVJJmf_Lbk06R2uduswUQg%40mail.gmail.com>
Precedence: bulk

--00000000000053748c05fe1d8434
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM M Sarwar <sarwarmd02@outlook.com> w=
rote:

>
> Please note in SQL-1 that test_number =3D 'TEST4P20 ' has a space and in
> SQL-2 there is no space test_number =3D '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.

--00000000000053748c05fe1d8434
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif">As noted on this page, the -general li=
st is a much more appropriate place to send this question.=C2=A0 Advocacy, =
not even close.<br></div><div class=3D"gmail_default" style=3D"font-family:=
arial,helvetica,sans-serif"><a href=3D"https://www.postgresql.org/list/">ht=
tps://www.postgresql.org/list/</a></div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif"><span style=3D"font-family:Aria=
l,Helvetica,sans-serif"><br></span></div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif"><span style=3D"font-family:Aria=
l,Helvetica,sans-serif">On Wed, Jun 14, 2023 at 2:08=E2=80=AFPM M Sarwar &l=
t;<a href=3D"mailto:sarwarmd02@outlook.com">sarwarmd02@outlook.com</a>&gt; =
wrote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div class=3D"msg1060381414236304637">


<div dir=3D"ltr">
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)"><br></div><div style=3D"font-family:Calibri,Helvetica,sans-ser=
if;font-size:12pt;color:rgb(0,0,0)">
<div>Please note in SQL-1 that test_number =3D &#39;<span style=3D"backgrou=
nd-color:rgb(255,255,255);display:inline">TEST4P20 &#39;</span>=E2=80=82has=
 a space and in SQL-2 there is no space=C2=A0<span style=3D"background-colo=
r:rgb(255,255,255);display:inline">test_number
 =3D &#39;TEST4P20&#39; has no space.</span></div>
<div><span style=3D"background-color:rgb(255,255,255);display:inline"><br>
</span></div>
<div><span style=3D"background-color:rgb(255,255,255);display:inline">Is it=
 not a bug?</span></div></div></div></div></blockquote><div><br></div><div>=
<div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-seri=
f">Doubtful.=C2=A0 You haven&#39;t provided actual data types here but it s=
eems you are using character instead of text.=C2=A0 Your desired behavior i=
s provided by the text data type.</div></div><div class=3D"gmail_default" s=
tyle=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gma=
il_default" style=3D"font-family:arial,helvetica,sans-serif">David J.</div>=
<div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-seri=
f"><br></div></div></div>

--00000000000053748c05fe1d8434--