Received: from uno.tksoft.com (uno.tksoft.com [206.117.169.102]) by hub.org (8.9.3/8.9.3) with ESMTP id VAA22686 for ; Thu, 15 Jul 1999 21:17:04 -0400 (EDT) (envelope-from tk@uno.tksoft.com) Received: (from tk@localhost) by uno.tksoft.com (8.8.8/8.8.8) id SAA10547 for pgsql-sql@postgreSQL.org; Thu, 15 Jul 1999 18:17:13 -0700 From: "tjk@tksoft.com" Message-Id: <199907160117.SAA10547@uno.tksoft.com> Subject: query length limits To: pgsql-sql@postgreSQL.org Date: Thu, 15 Jul 1999 18:17:13 -0700 (PDT) Content-Type: text 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? I could test this of course, but I am curious about the real limits imposed by the system, and any possible consequences, plus any changes planned in the future which might affect this issue. Thanks, Troy Troy Korjuslommi Tksoft OY, Inc. tjk@tksoft.com Software Development Open Source Solutions Hosting Services