On 12/21/2009 02:51 PM, alex pappas wrote:
The column in ported table was BIGINT but sqlops and avops take only string or int. I changed the colunm id table from BIGINT to INT and everything works fine! kamailio Rock's!!
Ah, yes, I have commonly run into this one as well. Yes, the database interface layers generally support only canonical scalar types - basic integer and varchar, as well as types that offer ready-made convertabiliy in a textual evaluation context (e.g. PostgreSQL boolean type, 't' or 'f').
No bigints unless you cast down to int. :)