Home > mailing lists

Re: select count of all overlapping geometries and return 0 if none. - Mailing list pgsql-sql

From	Peter Eisentraut
Subject	Re: select count of all overlapping geometries and return 0 if none.
Date	March 13, 2009 19:43:33
Msg-id	200903132143.24730.peter_e@gmx.net Whole thread Raw
In response to	select count of all overlapping geometries and return 0 if none. (Duffer Do <dufferdo25@yahoo.com>)
List	pgsql-sql

Tree view

On Thursday 12 March 2009 19:28:19 Duffer Do wrote:
> I want to return the following:
> locations    |  number_visits
> Frankfurt    |  6
> Manhattan  |  3
> Talahassee |  0
>
> My query only returns:
> Frankfurt    |  6
> Manhattan  | 3

> My query:
> SELECT count(user_name) as number_visits, location_name from locations,
> user_tracker WHERE user_geometry && location_geometry

I think something like this:

SELECT count(user_name) as number_visits, location_name FROM locations LEFT
JOIN user_tracker ON (user_geometry && location_geometry)

pgsql-sql by date:

From: Mina R Waheeb
Date: 13 March 2009, 18:38:16
Subject: Re: Permanent alias for postgresql table

From: Greenhorn
Date: 15 March 2009, 23:35:07
Subject: Oracle to PostgreSQL

Re: select count of all overlapping geometries and return 0 if none. - Mailing list pgsql-sql

Previous

Next