<p dir="ltr">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.</p>
<div class="gmail_quote">On Feb 23, 2015 9:59 AM, "Vlad Paiu" <<a href="mailto:vladpaiu@opensips.org">vladpaiu@opensips.org</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>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 cols="72">Vlad Paiu
OpenSIPS Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a> </pre>
On 23.02.2015 16:36, Patrick Wakano wrote:<br>
</div>
<blockquote 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></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div>