Mauricio,
unfortunatelly, this is not exactly what I need. PostGis supports SQL
extension allowing to write queires like:
SELECT
ST_AsBinary(ff.geom) As wkb
FROM ch01.fastfoods As ff
WHERE EXISTS(SELECT r.gid
FROM ch01.roads As r
WHERE ST_DWithin(ff.geom, r.geom, 1609*10)
AND r.name = 'US Route 1' AND r.state = 'MD'
AND ff.franchise = 'h');
And this extension is what I need.
On the other hand, ECQL is much simpler and allows only to write
quieries like:
name = 'US Route 1' AND state = 'MD'.
ECQL will not work for me, because I use OpenJump like 'visual
debugger' of the SQL quieries to PostGis database and was thinking
about using uDig instead.
Maybe I got you wrong, and Table view somehow allows to execute
arbitrary SQL?
Cheers,
Sergey
On 30.05.2011 18:07, Mauricio Pazos wrote:
On Monday, May 30, 2011
12:58:40 PM LSA wrote:
> Thats a pity, it would
be convinient...
Hi, maybe I was not clear.
It is implemented and you can experiment with it right now!.
It is available in Table
view.
cheers
--
Mauricio Pazos
www.axios.es
|
