Open
Description
- Which app are you using (JSON, XML, SQL):
SQL
- The steps to reproduce this issue:
PostgreSQL has an array contains and not contains operator using @> and <@. You can find some details here
https://www.postgresql.org/docs/11/functions-array.html
When this query is used to get formatted it's adding a space between the @ and > which is not valid.
Test Query
select *
from orders
where orders.tags @> '["tag1"]'
Turns into
select
*
from
orders
where
orders.tags @ > '["tag1"]'
which fill fail for operator does not exist: jsonb @
Metadata
Metadata
Assignees
Labels
No labels