Re: Wierded error in recursive function; debugging ideas?

From: Joe Conway <mail(at)joeconway(dot)com>
To: josh(at)agliodbs(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Wierded error in recursive function; debugging ideas?
Date: 2004-08-11 05:05:05
Message-ID: 4119A901.6060003@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Philippe Lang 2004-08-11 06:41:07 Re: function expression in FROM may not refer to other relations of same query level
Previous Message Josh Berkus 2004-08-11 04:56:25 Wierded error in recursive function; debugging ideas?