Simple Query Doesn't Even with Data

From: Scott Macri <Scott(at)BITSnBYTES(dot)io>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Simple Query Doesn't Even with Data
Date: 2022-03-10 01:40:45
Message-ID: 24fc9258007f1c08f8801936e2b7bdc8443f40b9.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a simple database with table, "map_table", and coulmn,
"company_letters". The database is populated and the first row
contains a value of 'abcdefg' in the company_letters column.

If I do a select * without a where clause I get the expected results.
However, when I execute the following select statement I was astonished
to see no results come back.  

Any idea what could possibly be wrong here?  

I've verified the data a 100 times and am totally perplexed. Thanks.

SELECT *
FROM public.map_table
WHERE company_letters = 'abcdefg';

--
Hacktorious

Responses

Browse pgsql-general by date

  From Date Subject
Next Message M Tarkeshwar Rao 2022-03-10 05:33:08 Could not read certificate file from while upgrading to PostgreSQLClient 12.9
Previous Message Lucas 2022-03-09 07:03:11 Postgres migration from 9.2 to 14