<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Note sure for te technical details, but instead of true/false, I
have t and f as checked and unchecked values.<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 08/28/2015 03:11 PM, Rémi Cura
wrote:<br>
</div>
<blockquote
cite="mid:CAJvUf_u5Geg2g8X6jw5+zfT7K1BTFdCW6dE-aEDZg16fDYdVjQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_default"
style="font-family:monospace,monospace">Hey,<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">some strange behaviour
here (2.6) :<br>
<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">In a postgis layer
over a postgis view<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">one of the view field
is a boolean<br>
<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">I chose the checkbox
for editing this field.<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">checked is "true",
unchecked is "false" , without the quote signs.<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace"><br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">When adding a new
geometry, all works as intended, the row inserted into the
database is the correct one.<br>
<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">But when trying to get
info about the geometry (arrow with the question mark), it
generates an error :<br>
<br>
1 cursor states lost.
<p style="margin:0px;text-indent:0px"> SQL: <br>
</p>
<p style="margin:0px;text-indent:0px">DECLARE qgis_12 BINARY
CURSOR FOR <br>
</p>
<p style="margin:0px;text-indent:0px">SELECT
st_asbinary("geom",'NDR')</p>
<p style="margin:0px;text-indent:0px">
,boolout("positionning_absolute")</p>
<p style="margin:0px;text-indent:0px"> ,"gid"::text</p>
<p style="margin:0px;text-indent:0px"> ,"type"::text</p>
<p style="margin:0px;text-indent:0px">
,"positionning_offset_type"::text</p>
<p style="margin:0px;text-indent:0px">
,"positionning_offset"::text</p>
<p style="margin:0px;text-indent:0px">
,"positionning_orientation_type"::text</p>
<p style="margin:0px;text-indent:0px">
,"positionning_orientation"::text</p>
<p style="margin:0px;text-indent:0px"> ,"curv_dist"::text <br>
</p>
<p style="margin:0px;text-indent:0px">FROM
"street_amp"."editing_street_object" <br>
</p>
<p style="margin:0px;text-indent:0px">WHERE
boolout("positionning_absolute")='t'</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
<p style="margin:0px;text-indent:0px"> Résultat: 7 (</p>
<p style="margin:0px;text-indent:0px">ERROR: operator does not
exist: cstring = unknown</p>
<p style="margin:0px;text-indent:0px"> LINE 1:
...ng_street_object" WHERE
boolout("positionning_absolute")='t'</p>
<p style="margin:0px;text-indent:0px"> ^</p>
<p style="margin:0px;text-indent:0px"> HINT: No operator
matches the given name and argument type(s). You might need
to add explicit type casts.</p>
<p style="margin:0px;text-indent:0px"> ) <br>
</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
<p style="margin:0px;text-indent:0px">I don't understand the
need to use the boolout function, <br>
</p>
<p style="margin:0px;text-indent:0px">it works simply without
it, and if you want to be extra sure, <br>
</p>
<p style="margin:0px;text-indent:0px">you could cast the text
to boolean safely (it is not necessary tough) <br>
</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
<p style="margin:0px;text-indent:0px">FROM
"street_amp"."editing_street_object" <br>
</p>
<p style="margin:0px;text-indent:0px">WHERE
"positionning_absolute"='t'::boolean</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
<p style="margin:0px;text-indent:0px">Cheers,</p>
<p style="margin:0px;text-indent:0px">Rémi-C<br>
</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-developer mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a></pre>
</blockquote>
<br>
</body>
</html>