Postgres Pro
Downloads
Home   >   mailing lists

Re: Wierded error in recursive function; debugging ideas? - Mailing list pgsql-sql

From Joe Conway
Subject Re: Wierded error in recursive function; debugging ideas?
Date
Msg-id 4119A901.6060003@joeconway.com
Whole thread Raw
In response to Wierded error in recursive function; debugging ideas?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Wierded error in recursive function; debugging ideas?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Wierded error in recursive function; debugging ideas?
Next
From: "Philippe Lang"
Date:
Subject: Re: function expression in FROM may not refer to other relations of same query level