Subject: Re: "SELECT IN" Still Broken in 7.4b
From: Rod Taylor <rbt@rbt.ca>
To: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: Mike Winter <mike.winter@frontlogic.com>,
	pgsql-sql@postgresql.org
In-Reply-To: <20030820103841.Q10580-100000@megazone.bigpanda.com>
References: <20030820103841.Q10580-100000@megazone.bigpanda.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-nDZ1+Iq0+cY2EgtxZXQN"
Message-Id: <1061412091.40948.65.camel@jester>
Mime-Version: 1.0
Date: Wed, 20 Aug 2003 20:41:32 +0000

--=-nDZ1+Iq0+cY2EgtxZXQN
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Wed, 2003-08-20 at 17:41, Stephan Szabo wrote:
> On Wed, 20 Aug 2003, Rod Taylor wrote:
>=20
> > > Thanks, Stephan.  I was really hoping that the IN(valuelist) was goin=
g to
> > > be changed at the same time, because it really is unusable for anythi=
ng
> > > over a couple of thousand values.
> >
> > Changed to do what?
>=20
> 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.

Is the temp table version any faster?  I realize it has a higher limit
to the number of items you can have in the list.

--=-nDZ1+Iq0+cY2EgtxZXQN
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/Q9z76DETLow6vwwRAiiKAJ9ECh4k0KxBXet6GgCB2qWFo5HOJwCfYlMl
Xn9AsCrUImT1TD6h0wJUjnQ=
=w3rw
-----END PGP SIGNATURE-----

--=-nDZ1+Iq0+cY2EgtxZXQN--