[OpenSIPS-Users] Boolean values from DB and avp
vladpaiu at opensips.org
Mon Feb 23 16:15:18 CET 2015
From the OpenSIPS lexer :
All of them are equivalent, and are correspondent to integer 1 and
respectively integer 0.
On 23.02.2015 17:09, Patrick Wakano wrote:
> Thank you very much for the answer Vlad!
> This raises me another question. I've been using boolean values with
> avp and found no problem so far. For instance, I set $avp(test) =
> true, and then use it in an "if" clause and everything works fine! But
> I'm really not sure if this is correct, and the docs are a little
> fuzzy regarding avp and boolean values. So can you clarify me what is
> the real support of boolean types in Opensips?
> On Mon, Feb 23, 2015 at 11:58 AM, Vlad Paiu <vladpaiu at opensips.org
> <mailto:vladpaiu at opensips.org>> wrote:
> In OpenSIPS, AVPs can have either integer or string values.
> For boolean values in Postgres, the module internally stores them
> as strings, so you will either get 't' or 'f' in your script - so
> yes, it's an OpenSIPS restriction in some ways.
> Best Regards,
> Vlad Paiu
> OpenSIPS Developer
> On 23.02.2015 16:36, Patrick Wakano wrote:
>> Hello list,
>> I've been using Opensips 11.3.1 with a Postgres DB 9.1 and
>> noticed that if I perform an avp_db_query call to retrieve any
>> boolean value from DB, the result gives me an avp with a string
>> and not the boolean value. For instance if I have any false value
>> in my DB, my avp_db_query gives me an avp with the string value
>> "f" and not the boolean value false.
>> Is this behaviour due to some misconfiguration in my DB or
>> Opensips, or is it an Opensips restriction? The docs shows "The
>> value type of the AVP (string or integer) will be derived from
>> the type of the columns." but have no mention to boolean...
>> Users mailing list
>> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
> Users mailing list
> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
> Users mailing list
> Users at lists.opensips.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Users