haskell-beam/beam

RUNTIME error: DEFAULT not allowed in this context

开放

#744 创建于 2025年2月21日

 (4 条评论) (0 个反应) (0 位负责人)Haskell (191 个派生)auto 404
breaking changebughelp wanted

仓库指标

星标
 (631 个星标)
PR 合并指标
 (PR 指标待抓取)

描述

I'm using PostgresSQL and I wanted to update a column to the default value if it was NULL. Beam happily accepts both (\r -> coalesce_ [just_ $current_ r.column] default_) and (\r -> if_ [isNothing_ (current_ r.column) then_ default_] (else_ $ current_ r.column))

But coalesce(r.column,DEFAULT) is not valid sql. I need to supply the default manually. I didn't find the proper way for this in beam, as the default is current_timestamp but the column is timstamptz in postgres corresponding to UTCTime in Haskell, but now_ in Beam only works for LocalTime . I got around it with using coerce_ now_ instead, but this doesn't feel right as it seems that GHC will happily coerce ANY beam type to one another...

(I have also used this coerce trick to get out of Maybe/Nullable when selecting only not null rows, haven't found a good way for this either.)

贡献者指南