[OSM-dev] query to the database matching ids without certain key

[Stephan Knauss]

Jon Burgess wrote:
> On Sun, 2009-08-09 at 21:27 +0200, Stephan Knauss wrote:
>> I want to get for example all airport nodes that miss a name.

I think I figured it out. There is a keyword "EXCEPT" that was unknown 
to me. I think it's providing the functionality I was looking for.

Can someone query the whole planet? I currently only have an excerpt. 
The result should be the same 454 nodes Jon got out of the mapnik table.

select airports.node_id from
   (select node_id from node_tags where v='aerodrome') as airports except
   (select distinct name.node_id from node_tags as name, node_tags as a
	where a.node_id=name.node_id and a.v='aerodrome' and (name.k='name'))


Stephan