<br><font size=2 face="sans-serif">Hallo Johannes,</font>
<br>
<br><font size=2 face="sans-serif">in version gvSIG 1.9 build 1445 the
following where statements worked fine for a test:</font>
<br>
<br><font size=2 face="sans-serif">where br_id = 2</font>
<br><font size=2 face="sans-serif">where text = 'KANSANGA'</font>
<br>
<br><font size=2 face="sans-serif">However more interesting is the question
if spatial functions will work too.</font>
<br>
<br><font size=2 face="sans-serif">BRGDS<br>
Karl</font>
<br>
<br><font size=2 face="sans-serif"> </font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>Johannes Valenta <spatialjoe@googlemail.com></b>
</font>
<br><font size=1 face="sans-serif">Sent by: gvsig_internacional-bounces@listserv.gva.es</font>
<p><font size=1 face="sans-serif">09/09/2009 11:27</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
Users and Developers mailing list <gvsig_internacional@listserv.gva.es></font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif">Users and Developers mailing list <gvsig_internacional@runas.cap.gva.es></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">[Gvsig_english] gvSIG 1.1.2 applying
SQL restriction on PostGIS layer while
loading</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=3>Hi list,<br>
<br>
this morning I come up with a fairly simple question (one might think).<br>
How do you apply a SQL restriction on a PostGIS layer while loading it?<br>
Searching the list via Nabble did not give any valuable results.<br>
<br>
For adding a Geodb-Layer the english manual states :<br>
"Any alphanumeric restriction must be introduced by means of
a valid SQL expression<br>
which is attached as a WHERE clause to each call to the database."<br>
<br>
Using <i>WHERE column = 'value' </i> ->did not work<br>
Using <i>WHERE column = "value"</i> ->did not
work<br>
Using <i>WHERE table.column = 'value'</i> ->did not work<br>
Using <i>WHERE table.column = "value"</i> ->did not
work<br>
Using all of the above using <i>where</i> ->did not work<br>
Using all of the above skipping <i>WHERE</i> ->did not work<br>
Using all of the above inserting the whole <i>SELECT</i>-Statement ->
did not work<br>
Using all of the above writing <i>IS </i>instead of<i> =</i> -> did
not work<br>
<br>
What else could be a valid expression?<br>
<br>
Loading the table first and filtering it afterwards by using the dialogue
i.e.<i><br>
column = 'value'</i> ->worked perfectly<br>
<br>
What do I miss?<br>
<br>
Pretty clueless in the morning (some coffee might help ;-)),<br>
<br>
Johannes<br>
<br>
<br>
<br>
-- <br>
This message has been scanned for viruses and <br>
dangerous content by </font><a href=http://www.mailscanner.info/><font size=3 color=blue><b><u>MailScanner</u></b></font></a><font size=3>,
and is <br>
believed to be clean. </font><tt><font size=2>_______________________________________________<br>
Gvsig_internacional mailing list<br>
Gvsig_internacional@listserv.gva.es<br>
</font></tt><a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional"><tt><font size=2>http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</font></tt></a><tt><font size=2><br>
</font></tt>
<br>