[Qgis-user] Feature Subset query builder
Hi List, A general question: Why does this query: area 100 area 1000 return the entire dataset, when this query (same but with brackets): (area 100) (area 1000) returns the correct subset? Surely they both evaluate to the same thing - my (limited) understanding of boolean logic says they both equate to the same thing because there is only the one logical operator so strictly speaking the brackets are not necessary. Is my understanding of the logic wrong, or should that work? Cheers, Jonathan -- This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Feature Subset query builder
Hi, what is the datasource you are testing? shp, postgres? -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Feature-Subset-query-builder-tp5071434p5071443.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Feature Subset query builder
Hi Regis, It's a SpatiaLite database. I just tested this in a couple of SQLite clients and they both exhibit the same behaviour, so I guess it's an SQLite issue. Weird. Thanks, Jonathan On 8 August 2013 10:31, Régis Haubourg regis.haubo...@eau-adour-garonne.frwrote: Hi, what is the datasource you are testing? shp, postgres? -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Feature-Subset-query-builder-tp5071434p5071443.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Feature Subset query builder
Jonathan Moules-2 wrote Hi List, A general question: Why does this query: area 100 area 1000 return the entire dataset, when this query (same but with brackets): (area 100) (area 1000) Hi , did you test something like this? area 100 AND area 1000 I'm afraid is not a logical operator but a text concatenator.. Régis -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Feature-Subset-query-builder-tp5071434p5071477.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Feature Subset query builder
Oooh, that works. I'm afraid using is a holdover from my MySQL days. I really should get in the habit of using and. Many thanks! Jonathan On 8 August 2013 13:31, Régis Haubourg regis.haubo...@eau-adour-garonne.frwrote: Jonathan Moules-2 wrote Hi List, A general question: Why does this query: area 100 area 1000 return the entire dataset, when this query (same but with brackets): (area 100) (area 1000) Hi , did you test something like this? area 100 AND area 1000 I'm afraid is not a logical operator but a text concatenator.. Régis -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Feature-Subset-query-builder-tp5071434p5071477.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user