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.<br><i>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>