[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Array to IN or UNION
From:       Richard Huxton <dev () archonet ! com>
Date:       2009-02-27 7:58:29
Message-ID: 49A79D25.5060109 () archonet ! com
[Download RAW message or body]

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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]