X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8764ED72AA for ; Fri, 14 Oct 2005 15:19:12 -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 61270-10 for ; Fri, 14 Oct 2005 18:19:04 +0000 (GMT) Received: from smtp103.rog.mail.re2.yahoo.com (smtp103.rog.mail.re2.yahoo.com [206.190.36.81]) by svr1.postgresql.org (Postfix) with SMTP id 45C24D93C7 for ; Fri, 14 Oct 2005 15:19:03 -0300 (ADT) Received: (qmail 37800 invoked from network); 14 Oct 2005 18:19:04 -0000 Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@209.222.54.227 with login) by smtp103.rog.mail.re2.yahoo.com with SMTP; 14 Oct 2005 18:19:04 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id B9B9C4173; Fri, 14 Oct 2005 14:19:03 -0400 (EDT) Date: Fri, 14 Oct 2005 14:19:03 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: cast Message-ID: <20051014181903.GC20107@phlogiston.dyndns.org> References: <1129313323.4577.55.camel@Desarrollo> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1129313323.4577.55.camel@Desarrollo> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.033 required=5 tests=[AWL=-0.017, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/173 X-Sequence-Number: 23026 On Fri, Oct 14, 2005 at 01:08:43PM -0500, Judith Altamirano Figueroa wrote: > Hello I have a query that ran in 7.0.2, but in 8.0.1 does not, the query > is the next: It'd help if we could see the table schema and the error message. A -- Andrew Sullivan | ajs@crankycanuck.ca When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes