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

[Tiller.Karl at nwsc.co.ug]

Hallo Johannes,

in version gvSIG 1.9 build 1445 the following where statements worked fine 
for a test:

where br_id = 2
where text = 'KANSANGA'

However more interesting is the question if spatial functions will work 
too.

BRGDS
Karl

 



Johannes Valenta <spatialjoe at googlemail.com> 
Sent by: gvsig_internacional-bounces at listserv.gva.es
09/09/2009 11:27
Please respond to
Users and Developers mailing list <gvsig_internacional at listserv.gva.es>


To
Users and Developers mailing list <gvsig_internacional at runas.cap.gva.es>
cc

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






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



-- 
This message has been scanned for viruses and 
dangerous content by MailScanner, and is 
believed to be clean. _______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional

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