[Haskelldb-users] Missing SQL features?!

[Immanuel N. <i.n...@ja...>]

Hello,

I can't find the SQL operators exists (and join) in HaskellDB. Are they
not supported yet or have they different names here?

Are nested selects possible?

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