Re: Simple Query Doesn't Even with Data

2022-03-10 Thread Ken Tanzer
On Thu, Mar 10, 2022 at 12:12 AM Scott Macri wrote: I've verified the data a 100 times and am totally perplexed. Thanks. > > SELECT * > FROM public.map_table > WHERE company_letters = 'abcdefg'; > > Not sure what kinds of verification you did, but did you check to make sure that there's no trail

Re: Simple Query Doesn't Even with Data

2022-03-10 Thread Julien Rouhaud
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_l

Simple Query Doesn't Even with Data

2022-03-10 Thread Scott Macri
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 se