Re: Why oh why is this join not working?

From: Pól Ua Laoínecháin <linehanp(at)tcd(dot)ie>
To: Bzzzz <lazyvirus(at)gmx(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Why oh why is this join not working?
Date: 2019-11-18 08:04:07
Message-ID: CAF4RT5RC59Q9PucEvChxo7CkTmXSrs86PChXFbeOcq7R78ttDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Pól Ua Laoínecháin 2019-11-18 08:18:37 Re: Why oh why is this join not working?
Previous Message Pól Ua Laoínecháin 2019-11-18 07:56:20 Re: Why oh why is this join not working?