Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Array to IN or UNION
- From: Richard Huxton <dev(at)archonet(dot)com>
- To: Jordi Romagos <jordi(dot)romagos(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Array to IN or UNION
- Date: Fri, 27 Feb 2009 07:58:29 +0000
- Message-id: <49A79D25.5060109@archonet.com> <text/plain>
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 versions of PG actually convert IN to ANY(<array>) - can you get a sample EXPLAIN ANALYSE output for your problem query? -- Richard Huxton Archonet Ltd
- References:
- Array to IN or UNION
- From: Jordi Romagos
- Array to IN or UNION
- Prev by Date: PostgreSQL to Oracle
- Next by Date: Re: PostgreSQL to Oracle
- Previous by thread: Array to IN or UNION
- Next by thread: Function parameter
- Indexes: