public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Wetmore, Matthew (CTR) <[email protected]>
Cc: mahesh <[email protected]>
Cc: Scott Ribe <[email protected]>
Cc: Mohammed Aslam <[email protected]>
Cc: [email protected]
Cc: Tom Lane <[email protected]>
Cc: M Sarwar <[email protected]>
Subject: Re: The same result for with SPACE and without SPACE
Date: Thu, 15 Jun 2023 08:53:20 -0700
Message-ID: <CAKFQuwY=FN8HBqofgqOE6s1v_nh1QbszWre7_Ryi1qV=MEigJA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <DM4PR19MB5978EB964FA1C7B55FFCB02DD35AA@DM4PR19MB5978.namprd19.prod.outlook.com>
	<DM4PR19MB59782360E0C452810D70CBE8D35AA@DM4PR19MB5978.namprd19.prod.outlook.com>
	<[email protected]>
	<DM4PR19MB59784B518F25D2C2292CA3FBD35AA@DM4PR19MB5978.namprd19.prod.outlook.com>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<CAJXhg9ByRV9QPVcW5MPi2c20g948Oxt8qU1DrcVb51fFgTEj2A@mail.gmail.com>
	<[email protected]>
	<[email protected]>

On Thu, Jun 15, 2023, 08:22 Wetmore, Matthew (CTR) <
[email protected]> wrote:

> Before you kick me out of the group, can you please explain.
>
>
>
> I thought the orig issue was that purposefully spaces/whitespace are being
> ignored (or not ignored.) in the select.  Maybe there was an email in the
> middle that I missed.
>
>
>
> create table matt_test (c1 int)
>
>
>
> insert into matt_test  values ('123')
>
>
>
> insert into matt_test  values (' 123')
>
>
>
> insert into matt_test values ('123 ')
>
>
>
> select c1 from matt_test where c1 = '123'
>
> -- all 3 rows returned.
>
>
>
> Is it expected behavior that all 3 rows would be returned (because the
> space isn’t an INT?)
>
>
>
> Works as I would expect with TEXT
>
>
>
> create table matt_test2 (c2 text)
>
>
>
> insert into matt_test2  values ('123')
>
>
>
> insert into matt_test2  values (' 123')
>
>
>
> insert into matt_test2  values ('123 ')
>
>
>
> select c2 from matt_test2 where c2 = '123'
>
> -- 1 rows returned.
>
>
If anything the inserts themselves should fail in trying to parse the
string to integers.  But that works just fine so all three rows have the
same integer output for the different inputs.

David J.

>

view thread (22+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: The same result for with SPACE and without SPACE
  In-Reply-To: <CAKFQuwY=FN8HBqofgqOE6s1v_nh1QbszWre7_Ryi1qV=MEigJA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox