Postgres Pro
Downloads
Home   >   mailing lists

Re: WHERE IN for JOIN subquery? - Mailing list pgsql-performance

From Dave Johansen
Subject Re: WHERE IN for JOIN subquery?
Date
Msg-id CAAcYxUciSL7FAaqEVpeLJEWeCtE+6Pv_j5AzZj4pErOn8+R5dw@mail.gmail.com
Whole thread Raw
In response to Re: WHERE IN for JOIN subquery?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-performance
Tree view
On Mon, Dec 18, 2017 at 5:10 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Dec 18, 2017 at 5:00 PM, Dave Johansen <davejohansen@gmail.com> wrote:

other = a.other
But I get this error:
ERROR:  invalid reference to FROM-clause entry for table "a"

LINE 1: ...ue), COUNT(DISTINCT value) FROM other WHERE other=a.other GR...

HINT:  There is an entry for table "a", but it cannot be referenced from this part of the query.

One possible solution to this error is to add the word "LATERAL" before LEFT JOIN so that the right side of the join can reference variables from the left side.

That appears to be what I was looking for.
Thanks,
Dave 

pgsql-performance by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: WHERE IN for JOIN subquery?
Next
From: Habib Nahas
Date:
Subject: Autoanalyze CPU usage