Re: Simple Query Doesn't Even with Data

On Thu, Mar 10, 2022 at 12:12 AM Scott Macri <Scott(at)bitsnbytes(dot)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
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.