|
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
|