Postgres Pro
Downloads
Home   >   mailing lists

Re: Why oh why is this join not working? - Mailing list pgsql-novice

From Pól Ua Laoínecháin
Subject Re: Why oh why is this join not working?
Date
Msg-id CAF4RT5RC59Q9PucEvChxo7CkTmXSrs86PChXFbeOcq7R78ttDw@mail.gmail.com
Whole thread Raw
In response to Re: Why oh why is this join not working?  (Bzzzz <lazyvirus@gmx.com>)
List pgsql-novice
Tree view 
Salut/Hi Jean-Yves, and merci for your input.

> What does:
>         EXPLAIN ANALYZE <query that fails>
> returns?

It returns exactly the same error as when the EXPLAIN ANALYZE is not there!

fiddle: https://dbfiddle.uk/?rdbms=postgres_12&fiddle=043de4fa23fa9fdfa98e8f46daae8e8f

Any other thoughts?


Pól...

> Jean-Yves

pgsql-novice by date:

Previous
From: Pól Ua Laoínecháin
Date:
Subject: Re: Why oh why is this join not working?
Next
From: Pól Ua Laoínecháin
Date:
Subject: Re: Why oh why is this join not working?