From: Immanuel N. <i.n...@ja...> - 2007-11-20 10:03:22
|
Hello, this is another try to get help about a question which I have send to this mailing list about 2 weeks ago under the subject "Missing SQL features". I haven't received any feedback may be because the traffic is rather low in this mailing list - so I try again: I can't find the SQL operators exists (and join) in HaskellDB. Are they not supported yet or have they different names here? Basically I need to express in HaskellDB something like: SELECT DISTINCT store_type FROM stores WHERE NOT EXISTS (SELECT * FROM cities_stores WHERE cities_stores.store_type = stores.store_type); (i.e. asking the question "What kind of store is present in no cities?") Any hints how to accomplish this in HaskellDB are highly appreciated. Thanks, Immanuel |