Re: SQL is fetching results BLANK checks but the data has no BLANKS

Yes, I am getting the same results for the following SQLs.

SELECT test_number
FROM bronx.test_test_details_all_mcm
WHERE test_description LIKE ' %'
;

* Count is 878

SELECT TEST_NUMBER
FROM BRONX.TEST_TEST_DETAILS_ALL_MCM
WHERE LEFT(TEST_DESCRIPTION, 1) = ' '
;
Count is 878

Thanks,
Sarwar

________________________________
From: Erik Wienhold <ewie(at)ewie(dot)name>
Sent: Wednesday, July 5, 2023 5:46 PM
To: M Sarwar <sarwarmd02(at)outlook(dot)com>; pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS

> On 05/07/2023 23:34 CEST M Sarwar <sarwarmd02(at)outlook(dot)com> wrote:
>
> Table has no indexes so far.

Do you get the same results when using LIKE instead?

SELECT test_number
FROM bronx.test_test_details_all_mcm
WHERE test_description LIKE ' %'

--
Erik