From: Ansley, Michael <Michael.Ansley@intec.co.za>
To: 'tjk@tksoft.com' <tjk@tksoft.com>
Cc: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: RE: query length limits
Date: Fri, 16 Jul 1999 09:06:37 +0200
Message-ID: <1BF7C7482189D211B03F00805F8527F70ED043@S-NATH-EXCH2> (raw)
Troy wrote:
>> Does Postgres have any limitations on
>> the length of queries?
>>
>> E.g. is "select one,two,three,...thousand from one,two,three,...thousand
where one = x and two is >> x and three is x and ... thousand = x" legal?
>>
Yes, there is. It is set to BLCKSZ * 2, at least in 6.5. BLCKSZ is
normally 8192 bytes, so your query size will be 16k. However, I'm busy
working on it at the moment, to make it unlimited (i.e.: limited by memory
available).
MikeA
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: Michael.Ansley@intec.co.za, tjk@tksoft.com
Subject: Re: query length limits
In-Reply-To: <1BF7C7482189D211B03F00805F8527F70ED043@S-NATH-EXCH2>
References: <1BF7C7482189D211B03F00805F8527F70ED043@S-NATH-EXCH2>
* 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