X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4FD0D528C9 for ; Tue, 24 May 2005 15:27:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87939-08 for ; Tue, 24 May 2005 18:27:02 +0000 (GMT) Received: from cougar.unisys.com.br (smtp2.unisys.com.br [200.220.0.118]) by svr1.postgresql.org (Postfix) with ESMTP id 981E5528C8 for ; Tue, 24 May 2005 15:26:59 -0300 (ADT) Received: from [192.168.0.1] ([200.155.195.226]) by cougar.unisys.com.br ; Tue, 24 May 2005 15:26:55 -0300 EST Message-ID: <429371EA.30502@pobox.com> Date: Tue, 24 May 2005 15:26:50 -0300 From: Alain User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: pt-br, pt MIME-Version: 1.0 To: Sql-Postgre Subject: Tip ? References: <05d801c41bd8$daf4f8f0$0403a8c0@fejleszt4> <42930447.2030801@gmail.com> In-Reply-To: <42930447.2030801@gmail.com> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Rcpt-To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/207 X-Sequence-Number: 21520 This tip was at the end of a message (from Szûcs Gábor). > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match it looks very important, but I cannot understand it. Sound as a small and easy mistake that can make things go sour... Can someone explain it please? thanks, Alain