From: markus brosch <brosch@gmx.de>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: max length of sql select statement ?
Date: 07 Jul 2003 18:23:55 +0200
Message-ID: <1057595035.881.119.camel@sam> (raw)
In-Reply-To: <20030707091855.O77173-100000@megazone23.bigpanda.com>
References: <20030707091855.O77173-100000@megazone23.bigpanda.com>
> > but how are you searching through your table with sql, when your SELECT
> > is against a collection of different elements (e.g. Array of Strings,
> > which should fit on one column and return all records which fit)
>
> Are the 'a', 'b', etc... fixed or generated on the fly? I'm not sure
> that the plan for a thousand OR clauses (or equivalently a thousand
> entries in a static IN) is going to necessarily be terribly good. You
> might have better luck setting it up to do a join with a table (possibly a
> temporary table if they're generated on the fly).
Generated "on the fly" by JDBC within Java ;-)
I already tried the join, but it takes ages *g*
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: brosch@gmx.de, sszabo@megazone23.bigpanda.com
Subject: Re: max length of sql select statement ?
In-Reply-To: <1057595035.881.119.camel@sam>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox