From: markus brosch <brosch@gmx.de>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: max length of sql select statement ?
Date: 07 Jul 2003 17:44:19 +0200
Message-ID: <1057592658.881.93.camel@sam> (raw)
Hi All!
I was searching the archive and was wondering why nobody asked this
strange(!) question (or I've not found it?):
"What is the max allowed length of a sql statement or query?"
I want to combine hundrets or thousands 'OR' within a select statement.
Possible or not (e.g: SELECT * FROM table WHERE col='a' OR col='b' OR
col='c' OR ...... )
This would be a very "dirty" or some would say, a "horrible" solution;
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)
Hope for help
cheers Markus - sql beginner ;-)
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
Subject: Re: max length of sql select statement ?
In-Reply-To: <1057592658.881.93.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