Hi, On Wed, Mar 09, 2022 at 08:40:45PM -0500, Scott Macri wrote: > > 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. > > SELECT * > FROM public.map_table > WHERE company_letters = 'abcdefg'; It looks like an index corruption, a REINDEX of that table should fix the problem. Did you update your system recently, which may have updated your libc/libicu version, or replicated data over different OS version (which could lead to the same problem)? If yes, it's a known problem and you have to reindex all indexes that uses collatable datatypes afterwards. You can look at https://wiki.postgresql.org/wiki/Locale_data_changes for more details about that problem.
