On Monday, December 7, 2020, Ken Tanzer <ken.tan...@gmail.com> wrote:
> > There's one last piece of this query I'm clearly not getting though. > Where it says: > > from foo as f, jsonb_to_recordset(js) as t(key2 text) > > what is actually going on there? I keep reading this as a table foo (f) > cross-joined to a table created by jsonb_to_recordset (t). But that > doesn't seem right, because rows from t are only joining with matching rows > from f, rather than all of them. Is there some unspoken implicit logic > going on here, or something else entirely that is going over my head? > That is the lateral join. https://www.postgresql.org/docs/current/sql-select.html Read the section under from, join, lateral. David J.
