Re: [SQL] The length of the sql query

2006-08-24 Thread Tom Lane
Emi Lu <[EMAIL PROTECTED]> writes: > Could someone tell me where I can find PostgreSQL doc about the query > length please The theoretical limit is 1Gb (because palloc won't allow creation of a longer string than that). The practical limit is probably a great deal less, especially if you don't h

Re: [SQL] The length of the sql query

2006-08-24 Thread Emi Lu
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

[SQL] The length of the sql query

2006-08-23 Thread Emi Lu
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