<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hello,<br>
<br>
In OpenSIPS, AVPs can have either integer or string values.<br>
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.<br>
<br>
Best Regards,<br>
<pre class="moz-signature" cols="72">Vlad Paiu
OpenSIPS Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a> </pre>
On 23.02.2015 16:36, Patrick Wakano wrote:<br>
</div>
<blockquote
cite="mid:CAPu3kNW3ZOfjnCekT3AscGETTb_Z_ZoLq5GMJrMmiy-Pos1WRA@mail.gmail.com"
type="cite">
<div dir="ltr">Hello list,
<div><br>
</div>
<div>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.</div>
<div>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...</div>
<div><br>
</div>
<div>Thanks,</div>
<div><br>
</div>
<div>Patrick</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>