Re: SQL is fetching results BLANK checks but the data has no BLANKS - Mailing list pgsql-admin

From Erik Wienhold
Subject Re: SQL is fetching results BLANK checks but the data has no BLANKS
Date
Msg-id 1358455621.855150.1688593586940@office.mailbox.org
Whole thread Raw
In response to Re: SQL is fetching results BLANK checks but the data has no BLANKS  (M Sarwar <sarwarmd02@outlook.com>)
Responses Re: SQL is fetching results BLANK checks but the data has no BLANKS
List pgsql-admin
> 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



pgsql-admin by date:

Previous
From: M Sarwar
Date:
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS
Next
From: M Sarwar
Date:
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS