| From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Cc: | kevin(at)meridianis(dot)com |
| Subject: | Re: Another sub-select problem... |
| Date: | 2003-05-23 11:00:14 |
| Message-ID: | 3ECDFF3E.22794F33@rodos.fzk.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
>
> The "IN(id_list)" portion is derived from a PHP-based recursive query
> and is passed into postgres based on user input--always a different
list
> of ID's. This seems to rule out a "JOIN" as an alternative query type
> which has been the general suggestion for avoiding the infamous "IN"
> issue which you are working on for 7.4.
>
You've seen several alternatives already, but my approach would be to
populate a temp table with the PHP-based recursive query id_list
(the COPY command offers a fast way to do so), and then JOIN on
that temp table.
Regards, Christoph
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-05-23 11:10:39 | Re: language "plpgsql" does not exist |
| Previous Message | Richard Huxton | 2003-05-23 10:26:31 | Re: language "plpgsql" does not exist |