Re: [SQL] failed to build any 5-way joins

Thanks Tom, but I think I can wait, being possible to use the exists clause and not having, at the moment a big database. When there will be the less-drastic fix you refer to, I will use it and change my query. Thanks again. Bye Alessandro Depase - Original Message - From: "Tom

Re: [SQL] failed to build any 5-way joins

in, compiled by GCC gcc (GCC) 3.3.1 (cygming special) Are there other ways to get a better insight? Alessandro Depase - Original Message - From: "Richard Huxton" <[EMAIL PROTECTED]> To: "Alessandro Depase" <[EMAIL PROTECTED]>; "Peter Eisentraut"

Re: [SQL] failed to build any 5-way joins

this error (well, besides the source, of course)? are there known limits in joining tables? Thanks again Bye Alessandro Depase CREATE TABLE public.info ( infoid varchar(10) NOT NULL, parent_infoid varchar(10), main_infoid varchar(10), fieldtypeid varchar(10) NOT NULL, CONSTRA

[SQL] failed to build any 5-way joins

hich they tell that PostgreSQL - v. 7.1.1 - passed the test with 64+ tables).   Thanks to you all for you help   Bye     Alessandro Depase