Re: Array to IN or UNION - Mailing list pgsql-general

From Richard Huxton
Subject Re: Array to IN or UNION
Date
Msg-id 49A79D25.5060109@archonet.com
Whole thread Raw
In response to Array to IN or UNION  (Jordi Romagos <jordi.romagos@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Abdul Rahman
Date:
Subject: PostgreSQL to Oracle
Next
From: Artacus
Date:
Subject: Re: PostgreSQL to Oracle