Re: [Geotools-devel] New functionality: creating new feature types with an sql query in jdbc data stores

[Christian M. <chr...@nv...>]

Hmmmmmm 

And how do you rewrite a query if the bbox param is missing ? 

e.g 

where st_area($bbox) > 100000 

or 

where anAttr = aValue or <bbox expresion> 

or 

where anAttr = aValue and <bbox expresion> 

? 

 

Andrea Aime writes: 

> Christian Müller ha scritto:
>> If I understand the concept, this feature will not add functionality.
>> The purpose is to make the statement more efficient
>> right ?
> 
> Correct. 
> 
> Though in fact in my mind it would make another class of usages
> possible in practical terms (as opposed to possible in theory
> but too slow for practical purposes beyond toy data sets),
> so I personally see it as a new functionality all right.
> In practical terms it would allow this patch to replace
> the geometryless datastore as well. 
> 
> Cheers
> Andrea 
> 
> 
> -- 
> Andrea Aime
> OpenGeo - http://opengeo.org
> Expert service straight from the developers.