Does SQL-99+ support an UNNEST operator, and if so, what are its semantics?

Asked Aug 29 '16 at 23:18

Active Sep 29 '22 at 17:16

Viewed 344 times

I can find UNNEST mentioned in the SQL-99 spec under collection derived table (I have a copy of the actual spec), but it never defines the semantics of such a construct...

From some further research, I'm just getting more confused. It looks like in SQL-99 (just from the grammar...) it looks like you can't use it in the SELECT list, which leaves me to wonder how you're supposed to actually use it? I guess LATERAL is required?

edited Aug 30 '16 at 22:19

asked Aug 29 '16 at 23:18

Bwmat

4,314
3
27
42

Which SQL-99 implementation are you using? Apparently, [PostgreSQL supports it](http://stackoverflow.com/questions/8760419/postgresql-unnest-with-element-number). – 500 - Internal Server Error Aug 30 '16 at 22:37
I'm looking at the spec itself. I'm working on a related spec – Bwmat Aug 30 '16 at 23:01

Does SQL-99+ support an UNNEST operator, and if so, what are its semantics?

0 Answers0