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@gmail.com>
Sent: Wednesday, July 5, 2023 6:06 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: Erik Wienhold <ewie@ewie.name>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS
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) = ' '