sqlc icon indicating copy to clipboard operation
sqlc copied to clipboard

UNNEST can't handle multiple arrays

Open danthegoodman1 opened this issue 1 year ago • 1 comments

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 exist

Database 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

danthegoodman1 avatar Jul 26 '24 14:07 danthegoodman1

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.

icedream avatar Jun 10 '25 13:06 icedream

Are there any known workarounds here?

judofyr avatar Jul 07 '25 12:07 judofyr