I have a SET column and have retrieved a value from it.
DECLARE types SET;
SET types = (SELECT...);
I'd like to iterate over types for each value of it.
How would I do this?
Asked
Active
Viewed 155 times
0
Lucien
- 776
- 3
- 12
- 40
-
Are you sure you need to loop through? Maybe a clever statement can do it in one step – juergen d Jun 19 '16 at 09:58
-
@TimBiegeleisen got it! Thanks! – Lucien Jun 19 '16 at 10:27
-
@juergend not sure about that but it's for a database that has 99.99% reads and 0.001% writes, so write speed doesn't matter too much to me. – Lucien Jun 19 '16 at 10:28