Re: SQL is fetching results BLANK checks but the data has no BLANKS
| От | M Sarwar |
|---|---|
| Тема | Re: SQL is fetching results BLANK checks but the data has no BLANKS |
| Дата | |
| Msg-id | DM4PR19MB5978BDD2F846D3239DD295EBD32FA@DM4PR19MB5978.namprd19.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: SQL is fetching results BLANK checks but the data has no BLANKS (Erik Wienhold <ewie@ewie.name>) |
| Ответы |
Re: SQL is fetching results BLANK checks but the data has no BLANKS
|
| Список | pgsql-admin |
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 ' %'
;
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@ewie.name>
Sent: Wednesday, July 5, 2023 5:46 PM
To: M Sarwar <sarwarmd02@outlook.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS
Sent: Wednesday, July 5, 2023 5:46 PM
To: M Sarwar <sarwarmd02@outlook.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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@outlook.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
>
> 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
В списке pgsql-admin по дате отправления: