Document query generated includes >= operation
Summary
When querying database with findDoc massive tries to use GIN index even for >= comparison operator.
Example
Code demonstrating the behavior
db.findDoc({ items:
[ {
type: 'charge',
referenceId: '3ab45f12-da72-42ab-b998-332aaac51d5f'
} ],
createdAt >=': 2019-01-16T05:00:00.000Z })
Expected behavior
I expect to generate query without >= for @> part of query
SELECT * FROM "sales" WHERE
"body" @> '{"items":[{"type":"charge","referenceId":"3ab45f12-da72-42ab-b998-332aaac51d5f"}]}'
AND ("body" ->> 'createdAt')::timestamptz >= '2019-01-16T05:00:00.000+00:00'
Actual behavior
But it generates following select query with >= key present in @>
SELECT * FROM "sales" WHERE
"body" @> '{"items":[{"type":"charge","referenceId":"3ab45f12-da72-42ab-b998-332aaac51d5f"}], "createdAt >=": "2019-01-16T05:00:00.000Z"}'
AND ("body" ->> 'createdAt')::timestamptz >= '2019-01-16T05:00:00.000+00:00'