Postgres Pro
Downloads
Home   >   mailing lists

Re: where in (select array) - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: where in (select array)
Date
Msg-id 2f4958ff0811200217n1ba5f5a9s27b625df8d411d0e@mail.gmail.com
Whole thread Raw
In response to where in (select array)  (Marcus Engene <mengpg2@engene.se>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: row-level security (Dynamically rewrite queries)
Next
From: Richard Huxton
Date:
Subject: Re: where in (select array)