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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: SQL is fetching results BLANK checks but the data has no BLANKS
Дата
Msg-id CAKFQuwb5L=GtRbPm88wKU8RC9T7vLfLrv0cSLfTWeg6LA-drng@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SQL is fetching results BLANK checks but the data has no BLANKS  (M Sarwar <sarwarmd02@outlook.com>)
Ответы Re: SQL is fetching results BLANK checks but the data has no BLANKS
Список pgsql-admin
Дерево обсуждения
On Wed, Jul 5, 2023 at 2:56 PM M Sarwar <sarwarmd02@outlook.com> wrote:
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 ' %'
;


How about:

SELECT test_number, '[' || test_description || ']'
FROM bronx.test_test_details_all_mcm
WHERE LEFT(TEST_DESCRIPTION, 1) = ' '
LIMIT 5;

?

David J.

В списке pgsql-admin по дате отправления: