Re: "SELECT IN" Still Broken in 7.4b - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: "SELECT IN" Still Broken in 7.4b
Date
Msg-id 20030820103841.Q10580-100000@megazone.bigpanda.com
Whole thread Raw
In response to Re: "SELECT IN" Still Broken in 7.4b  (Rod Taylor <rbt@rbt.ca>)
Responses Re: "SELECT IN" Still Broken in 7.4b  (Rod Taylor <rbt@rbt.ca>)
Re: "SELECT IN" Still Broken in 7.4b  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-sql
On Wed, 20 Aug 2003, Rod Taylor wrote:

> > Thanks, Stephan.  I was really hoping that the IN(valuelist) was going to
> > be changed at the same time, because it really is unusable for anything
> > over a couple of thousand values.
>
> Changed to do what?

One possibility might be to act as if the valuelist was a table and do the
IN as if it were that way, rather than treating it as a set of ORs.  That
would be basically like doing the temporary table solution, but without
requiring the user to do it.





pgsql-sql by date:

Previous
From: "Aasmund Midttun Godal"
Date:
Subject: Before/After Trigger User Switching
Next
From: Mike Winter
Date:
Subject: Re: "SELECT IN" Still Broken in 7.4b