How Slick update JSONB column in PG?

Asked Apr 11 '18 at 02:03

Active Apr 11 '18 at 03:30

Viewed 535 times

I try to update column attrs (JSONB type) in this way, it compiles failed.

table
   .filter(_.sn === param.sn)
   .map(_.attrs)
   .update(param.attrs)

But if I update a INTEGER column in the same way, it succeed.

How should I update a JSONB column by Slick ?

edited Apr 11 '18 at 03:30

asked Apr 11 '18 at 02:03

Z fp

Do you use slick-pg? (You have to in order to use JsonB types.) – Simon Apr 12 '18 at 13:47
@Simon Yes, I use slick-pg already. And the JSONB type is mapped to org.json4s.JsonAST.JValue type in Scala Class. But the codes above still compiles failed. – Z fp Apr 13 '18 at 03:22

0 Answers0