[OpenSIPS-Users] Boolean values from DB and avp

Podrigal, Aron aronp at guaranteedplus.com
Mon Feb 23 16:05:20 CET 2015


just as a side note, in postgres boolean values maybe stored as either case
't' 'T' 'f' 'F' , in most cases  it will be the lower case version.
On Feb 23, 2015 9:59 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/fe391e80/attachment.htm>


More information about the Users mailing list