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

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

David,

        SELECT test_number

        FROM bronx.test_test_details_all_mcm
        WHERE test_description LIKE ' %'

;

"TEST1P1   "        "[ 1.8V Continuity (274 pins) ]"

"TEST1P2   "        "[ DDR3 Continuity (287 pins) ]"

"TEST1P3   "        "[ PCIe Continuity (82 pins) ]"

"TEST2P1   "        "[ CLK_REF_A_IN Differential ]"

"TEST2P2   "        "[ DDR3_REF_CLOCK Differential ]"

They do have a space at the beginning. My bad.

Thank you,

Sarwar

---

From: David G. Johnston <david.g.johnston@xxxxxxxxx>
Sent: Wednesday, July 5, 2023 6:06 PM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Cc: Erik Wienhold <ewie@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS

 

On Wed, Jul 5, 2023 at 2:56 PM M Sarwar <sarwarmd02@xxxxxxxxxxx> 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.