21 Dec
2009
21 Dec
'09
10 p.m.
Alex,
What do you suggest for faster sql queries with mysqlp :
avpops or sqlops ?
Cheers
Alex
On Mon, Dec 21, 2009 at 9:55 PM, Alex Balashov <abalashov(a)evaristesys.com>wrote;wrote:
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. :)
--
Alex Balashov - Principal
Evariste Systems
Web : http://www.evaristesys.com/
Tel : (+1) (678) 954-0670
Direct : (+1) (678) 954-0671