[OpenSIPS-Users] Boolean values from DB and avp
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:
> 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...
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
> Users mailing list
> Users at lists.opensips.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Users