[Haskelldb-users] where Not in ...

[Guenther S. <gue...@we...>]

Hi,

I'm trying to select records whose caseId are *not* present in another 
table.

I did a `minus` thingy on the caseIds but then the restrict clause 
causes a run-time
"No match in record selector"
and that spoils the fun.

How *can* I select records that are not present in another table?

Günther

Justin, haskelldb-users, is that currently just you and me?




nonProcs = do
  r <- table casesWithRGs
  p <- table procedureCnts
  n <- (project (caseId << r!caseId)) `minus` (project (caseId << p!caseId))
  l <- table leistungIndices
  restrict (n!caseId  .==. l!caseId)
  project (caseId << l!caseId
           # dummyDouble << _sum (l!opLstgIdx))