From: | markus brosch <brosch(at)gmx(dot)de> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: max length of sql select statement ? |
Date: | 2003-07-07 16:23:55 |
Message-ID: | 1057595035.881.119.camel@sam |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> > 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*
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleus Mantzios | 2003-07-07 17:05:43 | Re: create view error |
Previous Message | Stephan Szabo | 2003-07-07 16:23:39 | Re: max length of sql select statement ? |