-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Emi Lu wrote: > 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. Wouldn't the "need" to create such a huge query indicate that that is the wrong solution to the problem? - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFE7bUfS9HxQb37XmcRAl7aAJ9PgoKb/jYRVFwi1/JZ5wY+n44W1QCeL4v7 4CD71Cuzs5q1M1XknMKVeYw= =fPiZ -----END PGP SIGNATURE-----
