Repository navigation
UNNEST can't handle multiple arrays #3507
Description
Version
1.26.0
What happened?
See linked playground. If you make it a single array it works fine.
Supported since postgres 9.4
Relevant log output
function unnest(unknown, unknown, unknown) does not existDatabase schema
No response
SQL queries
No response
Configuration
No response
Playground URL
https://play.sqlc.dev/p/177bd0ee17908bc7f1a1e1fe4302562aa99013a7f3a6e3d0b6d92a50bb7d8fd3
What operating system are you using?
No response
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go
Reacted by Hector Jusforgues, fabianthetreep, Stephen Brian King, Bent Fladmark, Mathias Tværmose Gleerup, Andy Kramolisch, idod, Charith Ellawala, amirmd76, Carl Kittelberger and 18 more
Activity
fix: Support multi-argument version of unnest
icedream commentedon Jun 10, 2025
I've seen the PR has been around since December. Would it get the PR accepted quicker if someone else were to test with their own SQL? I've noticed this being an issue, and the change looks very simple and logical.
judofyr commentedon Jul 7, 2025
Are there any known workarounds here?
jordanst3wart commentedon Mar 25, 2026
Relates to: #958
bad workaround with JSONB mentioned