[OpenSIPS-Users] Boolean values from DB and avp

[Patrick Wakano]

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?

Regards,
Patrick


On Mon, Feb 23, 2015 at 11:58 AM, Vlad Paiu <vladpaiu at opensips.org> wrote:

>  Hello,
>
> 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 Developerhttp://www.opensips-solutions.com
>
> 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...
>
>  Thanks,
>
>  Patrick
>
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150223/92c50ba3/attachment.htm>