RE: query length limits

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