[Gvsig_english] gvSIG 1.1.2 applying SQL restriction on PostGIS layer while loading

[Johannes Valenta]

Hi list,

this morning I come up with a fairly simple question (one might think).
How do you apply a SQL restriction on a PostGIS layer while loading it?
Searching the list via Nabble did not give any valuable results.

For adding a Geodb-Layer the english manual states :
 "Any alphanumeric restriction must be introduced by means of a valid SQL
expression
which is attached as a WHERE clause to each call to the database."

Using  *WHERE column = 'value' * ->did not work
Using  *WHERE  column = "value"* ->did not work
Using  *WHERE table.column = 'value'* ->did not work
Using  *WHERE table.column = "value"* ->did not work
Using all of the above using *where* ->did not work
Using all of the above skipping *WHERE* ->did not work
Using all of the above inserting the whole *SELECT*-Statement -> did not
work
Using all of the above writing *IS *instead of* =* -> did not work

What else could be a valid expression?

Loading the table first and filtering it afterwards by using the dialogue
i.e.
*column = 'value'*  ->worked perfectly

What do I miss?

Pretty clueless in the morning (some coffee might help ;-)),

Johannes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20090909/e0ad4c89/attachment.htm