You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, i am currently working on postgres database with nullable column type. In postgres, you can not use foo = NULL expression but foo IS NULL. As far as i read the sea-query documentation i can only use Expr::col(TableIden::Foo).eq(option_variable) as equality comparison expression and if option_variable value is None, it produce foo = NULL. Is there any possible way to handle binary expression for nullable column type without manual checking?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi, i am currently working on postgres database with nullable column type. In postgres, you can not use
foo = NULL
expression butfoo IS NULL
. As far as i read thesea-query
documentation i can only useExpr::col(TableIden::Foo).eq(option_variable)
as equality comparison expression and ifoption_variable
value isNone
, it producefoo = NULL
. Is there any possible way to handle binary expression for nullable column type without manual checking?Beta Was this translation helpful? Give feedback.
All reactions