[OpenSER-Users] Re: AVPs and PostgreSQL data types.

[Christian Schlatter]

Alex Balashov wrote:
> On Fri, 12 Oct 2007, Alex Balashov wrote:
> 
>> Is there any way to fix this?  I have tried using CAST() in the SQL
>> statement, but that did not appear to help.
> 
>   In other words, I tried:
> 
>      avp_db_query("SELECT my_stored_proc(CAST('$avp(S:my_avp)' AS 
> bigint))");

It looks like the return type of my_stored_proc is not known by the 
openser postgres module. Postgres OID 869 is mapped to type 'inet', 
which I guess is IP address. Maybe, instead of returning 'inet', your 
stored procedure could return 'string'.

On the other hand, the warning you get from the postgres module is just 
a notification that the return value is treated as string.

/Christian

> 
>   But same error results.
> 
> -- 
> Alex Balashov
> Evariste Systems
> Web    : http://www.evaristesys.com/
> Tel    : +1-678-954-0670
> Direct : +1-678-954-0671
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users