Re: [GENERAL] Array to IN or UNION

2009-02-26 Thread Richard Huxton
Jordi Romagos wrote: > I'm doing a procedure and I'm trying to pass a dynamic array into a CURSOR, > I found the sentence ANY but it's really slow. Is there any way to convert > all the elements in this array to IN condition or one select with unions? > For example, I've got a feeling that recent

[GENERAL] Array to IN or UNION

2009-02-26 Thread Jordi Romagos
I'm doing a procedure and I'm trying to pass a dynamic array into a CURSOR, I found the sentence ANY but it's really slow. Is there any way to convert all the elements in this array to IN condition or one select with unions? For example, BEGIN example CURSOR (codes integer[] ) SELECT * FRO