Sv: SQL queries not matching on certain fields

2019-04-03 Thread Andreas Joseph Krogh
På onsdag 03. april 2019 kl. 15:06:03, skrev Felix Ableitner mailto:m...@nutomic.com>>: Hello, I'm having a very strange problem with the Postgres database for my website. Some SQL queries are not matching on certain fields. I am running these commands via the psql command. Here is a query tha

Re: SQL queries not matching on certain fields

2019-04-03 Thread Torsten Förtsch
Broken index? I had a similar problem a while ago. We were streaming a DB from a Debian box to an alpine docker image. The underlying system libraries were a little different and that resulted in broken index behavior. On Wed, Apr 3, 2019 at 3:06 PM Felix Ableitner wrote: > Hello, > > I'm havin

Re: SQL queries not matching on certain fields

2019-04-03 Thread Steve Atkins
> On Apr 3, 2019, at 2:06 PM, Felix Ableitner wrote: > > Hello, > > I'm having a very strange problem with the Postgres database for my website. > Some SQL queries are not matching on certain fields. I am running these > commands via the psql command. > > Here is a query that works as expe

SQL queries not matching on certain fields

2019-04-03 Thread Felix Ableitner
Hello, I'm having a very strange problem with the Postgres database for my website. Some SQL queries are not matching on certain fields. I am running these commands via the psql command. Here is a query that works as expected: # SELECT id, "preferredUsername" FROM actor WHERE "preferredUsername"