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 2FEC214B281D for ; Wed, 11 Aug 2004 02:05:10 -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 32902-01 for ; Wed, 11 Aug 2004 05:05:05 +0000 (GMT) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id 7458814B281A for ; Wed, 11 Aug 2004 02:05:05 -0300 (ADT) Received: from [192.168.4.3] (account jconway [192.168.4.3] verified) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 2103818; Tue, 10 Aug 2004 21:57:42 -0700 Message-ID: <4119A901.6060003@joeconway.com> Date: Tue, 10 Aug 2004 22:05:05 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040803 X-Accept-Language: en-us, en MIME-Version: 1.0 To: josh@agliodbs.com Cc: pgsql-sql@postgresql.org Subject: Re: Wierded error in recursive function; debugging ideas? References: <200408102156.25803.josh@agliodbs.com> In-Reply-To: <200408102156.25803.josh@agliodbs.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/79 X-Sequence-Number: 18576 Josh Berkus wrote: > I'm seeing this bizarre, unreproducable error in my logs: > > [2] Wrong datatype for second argument in call to in_array > SQL: SELECT sf_event_decendants(66645,111) > I also checked for in_array and it's not a visible built-in function. Is this > maybe a PostgreSQL bug? Version is 7.4.1 > There is no in_array() function in Postgres that I'm aware of -- you sure that isn't array_in()? The rest of that error message doesn't seem to be there in 7.4 either. Can we see the function? Joe