Range operators cannot be used inside `or` without quoting about postgrest HOT 6 CLOSED

I think it should be in the next section, so not operators, but logical operators: https://postgrest.org/en/v12/references/api/tables_views.html#logical-operators

from postgrest.

Did you try to quote the value instead?

curl -g 'localhost:3000/ranges?or=(range.adj."[3,10)")&select=id'

from postgrest.

Works!

curl -g 'localhost:3000/ranges?or=(range.adj."(3,10]")&select=id'

[{"id":1}]

I guess still a bug though.

from postgrest.

I guess still a bug though.

Huh? It works as designed. I really don't see the bug.

from postgrest.

Right, maybe this is just a matter of docs then. It would be nice to have a mention about this gotcha on https://postgrest.org/en/v12/references/api/tables_views.html#operators

from postgrest.

Maybe this is related and should be added to the docs too. From this discussion #3466 (comment):

curl --globoff 'http://example.com/table?select=*&and=(column->jsonlist.cs.["foo=()"]'

results in

{"code":"22P02","details":"Token \"\"foo=(\" is invalid.","hint":null,"message":"invalid input syntax for type json"}

The solution is to wrap the whole JSON array value inside quotations, (not just the items). That is:

curl --globoff 'http://example.com/table?select=*&and=(column->jsonlist.cs."[\"foo=()\"]"'

from postgrest.