Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: ArtacusDate: 2009-02-27 08:10:43
Subject: Re: PostgreSQL to Oracle
Previous:From: Abdul RahmanDate: 2009-02-27 06:36:56
Subject: PostgreSQL to Oracle

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group