We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
The following use of JSON_modifier_list works:
select cast('[1,2,3]' as json) is json value; select cast('[1,2,3]' as json) is json object; select cast('[1,2,3]' as json) is json array; select cast('[1,2,3]' as json) is json (array, object, value); select cast('[1,2,3]' as json) is json scalar;
However, when using a JSON_scalar_modifier a syntax error is produced:
JSON_scalar_modifier
select cast('1' as json) is json scalar number; select cast('2' as json) is json scalar string; select cast('3' as json) is json scalar binary_double; select cast('4' as json) is json (scalar binary_double, scalar number, scalar string);
The text was updated successfully, but these errors were encountered:
Functionality worked in 23.3 but was not documented in F47038-0 which was the basis for the implementation. Hence I tag it with 23.4
Sorry, something went wrong.
rolandstirnimann
No branches or pull requests
The following use of JSON_modifier_list works:
However, when using a
JSON_scalar_modifier
a syntax error is produced:The text was updated successfully, but these errors were encountered: