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) -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql