SQL iterate through arrays

Question

Is there a way to iterate through an array in SQL not using stored procedures? For instance given:

a | b
--+------
a | {1,2}

I would like to flatten the array into individual rows as in:

a | b
--+---
a | 1
a | 2

Clarification: I am trying to do this in Postgres and am looking for a pure SQL solution as opposed to using stored procedures. Please correct me if I am wrong but I don't think this has been addressed in previous questions. Thanks!

@muistooshort, Yes, my mistake. How do you unvote-to-delete? — Ben
– Ben, Commented Mar 7, 2013 at 13:55
@Ben: I don't think you can, maybe check meta.stackoverflow.com. Anyway, it takes five votes to close so hopefully people will be responsible and read the comments before agreeing with you :) I'm pretty sure we've all made bad close-votes. — mu is too short
– mu is too short, Commented Mar 7, 2013 at 18:21

Clodoaldo Neto · Accepted Answer · 2013-03-06 16:13:47Z

2

Very simple

select a, unnest(b)
from t

answered Mar 6, 2013 at 16:13

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL iterate through arrays

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related