Is it possible to add custom operator in where method?

[un1t]

Hi!

I use Postgres with jsonb field. I would like to write come expressions like this:

select * from table where data::jsonb @> '{"1" : [8]}';

I did try to put sting as argument in where method.

> Query().from_table('t').where("""data::jsonb @> '{"1" : [8]}""").get_sql()
'SELECT t.* FROM t WHERE ()'

[somewes]

Hey @un1t, there currently isn't support for the "@>" operator or custom ones at the moment. Do you know if that type of operator works with django 1.9's jsonb support? I can look into adding support for this and other jsonb related expressions.

[un1t]

Postgres has many operators for jsonb and other types. Django supports only few of them.