Re: where in (select array)

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "Marcus Engene" <mengpg2(at)engene(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: where in (select array)
Date: 2008-11-20 10:17:59
Message-ID: 2f4958ff0811200217n1ba5f5a9s27b625df8d411d0e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

just as a little advice, I would actually use joins - for performance
reasons. 'where in' seems to be rather slow, especially if you use it on
large sets of data.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-11-20 10:33:30 Re: where in (select array)
Previous Message Richard Huxton 2008-11-20 10:11:47 Re: row-level security (Dynamically rewrite queries)