Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C6383650E78 for ; Thu, 26 Jun 2008 04:13:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21070-02 for ; Thu, 26 Jun 2008 04:13:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.173]) by postgresql.org (Postfix) with ESMTP id 86B92650EA6 for ; Thu, 26 Jun 2008 04:12:57 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 25so3407356wfc.28 for ; Thu, 26 Jun 2008 00:12:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=sbVzfXffrkv4YtATKFoOK2jVysJHrIg0Vx9K0XlqWEY=; b=tnW5FwMtl9EUyc18bRhO93cu4RyAaYukRK3cV0gcRACN4YpdmEvmKdtiHI845pW2rU cEDQOAcoTgf3GufFP/JeGcG2o5Nylc58x8MVp/BUWsSfbbC1LTbsT7A9Aey4PA5oIs9t 3MTUaC9N3QuSSaV8g0viGeD8VlRiqLuH58fjY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=L2O37JeRdxcRyhF/C+uXLK5El2JQq5iZuf5vSxEd/ZvLfGNzkhEocDT+OLcn347j/m igPWIQTQIKZHSD4N5+v5abJjFmTnjlSXtkpVv19EIjqg2EGBDbGoqdJddcphgBCh7iJN lV/M3YF7irhEjXNAzBZdENBgHvx/+e23VZYk8= Received: by 10.142.158.17 with SMTP id g17mr7393614wfe.17.1214464376136; Thu, 26 Jun 2008 00:12:56 -0700 (PDT) Received: by 10.142.188.15 with HTTP; Thu, 26 Jun 2008 00:12:56 -0700 (PDT) Message-ID: <1d4e0c10806260012pef3b340y2ec5e5855d18974c@mail.gmail.com> Date: Thu, 26 Jun 2008 09:12:56 +0200 From: "Guillaume Smet" To: "Frank Joerdens" Subject: Re: Typecast bug? Cc: "Craig James" , pgsql-performance@postgresql.org In-Reply-To: <7d10d2df0806260002w8707ea1rf8f62ca8126099a8@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <544D07A2-EB3F-4D91-A749-0C4D5D38AB80@gmail.com> <481F992D.7070509@emolecules.com> <4820A3C2.4000307@emolecules.com> <4820C30A.8010709@emolecules.com> <4863186E.1000306@emolecules.com> <7d10d2df0806260002w8707ea1rf8f62ca8126099a8@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/160 X-Sequence-Number: 30510 On Thu, Jun 26, 2008 at 9:02 AM, Frank Joerdens wrote: > Which version are you using? 8.3 removes a lot of implicit casts (all? > not sure), so this may already be your fix. 8.3 only removed implicit casts from non text types to text (date -> text, int -> text, interval -> text...) to avoid unexpected behaviours. -- Guillaume