Re: Simple Query Doesn't Even with Data
On Thu, Mar 10, 2022 at 12:12 AM Scott Macri <Scott@bitsnbytes.io> 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 trailing whitespace?
What do you see for that row if you run this query?
SELECT company_letters,length(company_letters),company_letters='abcdefg',trim(company_letters)='abcdefg' FROM public.map_table;
AGENCY Software
A Free Software data system
By and for non-profits
(253) 245-3801
learn more about AGENCY or
follow the discussion.
В списке pgsql-general по дате отправления: