Checking for NULL columns (equivalent to IS NULL or IS NOT NULL)

[Mathew de Detrich]

Is there a way to check if a column is NULL in squeryl, obviously
using === gives the paraphrased "not an int" type error

Or are you forced to use pure SQL?

[Maxime Lévesque]

where(x.aField isNull)

The list of operators and functions is here :

 http://squeryl.org/functions.html

ML

2011/8/6 Mathew de Detrich <det...@gmail.com>

[Peter Leong]

In case anyone else is pulling their hair out...

where(x.aField.isNull)

Seems to play nicer with my IDE.  It works for Option[] fields too.

Pete