Message-ID: <44EDA277.90704@encs.concordia.ca>
Date: Thu, 24 Aug 2006 08:58:31 -0400
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Thunderbird 1.5.0.5 (X11/20060719)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: The length of the sql query
References: <44EC961F.4060106@encs.concordia.ca>
In-Reply-To: <44EC961F.4060106@encs.concordia.ca>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

It appears in MySql 3.23 the limit is 16 MB.  In 4.0 and later, it is 1 GB

http://dev.mysql.com/doc/refman/4.1/en/packet-too-large.html


Could someone tell me where I can find PostgreSQL doc about the query 
length please
Tks a lot!

> Hello,
>
> Just curious to know whether postgresql has any length constraint 
> about where part, such as
>
>
> Query =
> [
> select col1, col2, ... coln
> from table 1, table2,
> where
>
> constraint1 + constraint2 +................................constraintN
> ]
>
> Is there any length arrange for the Query str such as 500M, 1G, etc? 
> Or the query can be as long as it is.
>
> Thanks a lot!
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings