4 ms·
Yes, I have a similar only usage but using JSONB_EACH. You can actually replace "CROSS JOIN LATERAL" with a comma which I think is clearer. However, it working
by urams 5mo ago
Yes, I have a similar only usage but using JSONB_EACH. You can actually replace "CROSS JOIN LATERAL" with a comma which I think is clearer.
However, it working as a lateral join is critical as you need the function to fire for every row.
- rdevilla 5mo ago> However, it working as a lateral join is critical as you need the function to fire for every row. Right, what I mean is, for functions in the standard expression position, e.g. `SELECT COALESCE(..., 0)`, those functions will also fire for every row. jsonb_to_recordset however needs to know the schema of the table it will output, and the only way syntactically to declare the column types output by a function returning a recordset is in LATERAL clauses [0]. [0] https://www.postgresql.org/docs/current/sql-select.html https://www.postgresql.org/docs/current/sql-select.html