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

From: Erik Wienhold <ewie(at)ewie(dot)name>
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
Date: 2023-07-05 21:46:26
Message-ID: 1358455621.855150.1688593586940@office.mailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message M Sarwar 2023-07-05 21:56:31 Re: SQL is fetching results BLANK checks but the data has no BLANKS
Previous Message M Sarwar 2023-07-05 21:34:31 Re: SQL is fetching results BLANK checks but the data has no BLANKS