Open noskovvkirill opened 7 months ago
Thanks for the report. I can reproduce:
curl 'localhost:3000/bets?data_json->@type=eq.4'
{"code":"PGRST100","details":"unexpected \"@\" expecting \"-\", digit or field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse tree path (data_json->@type)\" (line 1, column 12)"}
As a workaround, you could do:
.eq('media3Id->data->>schemaOrg2', {"@type": 1})
I've confirmed this works:
curl 'localhost:3000/jsontest?json->a->b=eq.\{"@type":1\}'
[{"json":{"a": {"b": {"@type": 1}}},"integer":1}]
Wrapping the key in quotations seems to work:
curl "http://localhost:3000/jsonvals?a->>\"@key\"=eq.1"
[{"@key":"1"}]
Doing this should work as another workaround:
.eq('media3Id->data->>schemaOrg2->>"@type"', schemaPrefix)
Bug report
Describe the bug
Hi! We are trying to query the data from our jsonb column that has a special symbol @. We are following the recommended spec by schema-dts
This is an example of code snippet we run:
This is the result that we see
Is there anything that we are missing?
To Reproduce