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@openser.org
http://openser.org/cgi-bin/mailman/listinfo/users


_______________________________________________
Users mailing list
Users@openser.org
http://openser.org/cgi-bin/mailman/listinfo/users

Reply via email to