Home > mailing lists

Re: Simple Query Doesn't Even with Data - Mailing list pgsql-general

From	Ken Tanzer
Subject	Re: Simple Query Doesn't Even with Data
Date	March 10, 2022 11:30:46
Msg-id	CAD3a31V=-_HP=KZaiU2qvqKZQGEO-e9Mg4MtoP=SW4itmjZ4tQ@mail.gmail.com Whole thread Raw
In response to	Simple Query Doesn't Even with Data (Scott Macri <Scott@BITSnBYTES.io>)
List	pgsql-general

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

http://agency-software.org/

https://demo.agency-software.org/client

(253) 245-3801

learn more about AGENCY or

follow the discussion.

From: Julien Rouhaud
Date: 10 March 2022, 11:20:27
Subject: Re: Simple Query Doesn't Even with Data

From: Luca Ferrari
Date: 10 March 2022, 16:51:16
Subject: primary_conninfo and restore_command ?