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: 2009-02-27 07:58:29
Message-ID: 49A79D25.5060109@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Artacus 2009-02-27 08:10:43 Re: PostgreSQL to Oracle
Previous Message Abdul Rahman 2009-02-27 06:36:56 PostgreSQL to Oracle