[Mapserver-DE] Probleme bei der Abfrage von POSTGIS

Jürgen E. Fischer jef at norbit.de
Fre Mar 17 16:08:08 CET 2006


Moin Klaus,

On Fri, Mar 17, 2006 at 13:44:28 +0100, KlausSchiefer wrote:
> the_geom from (select lk.the_geom as the_geom, lk.gid as oid, lage from
> lage_k lk, poi p where distance(lk.the_geom, p.the_geom) < 150 and
> p.bezeichnung = 'Apotheken' AND lk.lage LIKE '03L%' AND datum >= '2006/03/11
> 00:00:00' AND datum <= '2006/03/17 23:59:59' ORDER BY lage DESC) AS
> new_table USING UNIQUE oid USING SRID=31466

Geht's so?

the_geom from (
	select lk.the_geom as the_geom, lk.gid as oid, lk.lage from lage_k lk where
		exists (select * from poi p where distance(lk.the_geom, p.the_geom)<150 and p.bezeichnung='Apotheken') AND
		lk.lage LIKE '03L%' AND datum >= '2006/03/11 > 00:00:00' AND datum <= '2006/03/17 23:59:59'
) AS new_table USING UNIQUE oid USING SRID=31466


hth
Jürgen

-- 
Jürgen Fischer            norBIT GmbH               Tel. +49-4931-918175-31
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de
    Men of few words are the best men -- William Shakespeare, "Henry V"