|
|
|
|
|
|
by rdevilla
57 days 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 |
|
|