New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

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

Jump to bottom

Looking up JSON using more than 1 array doesn't work #23

Open

samuelcolvin opened this issue Jun 28, 2024 · 1 comment

Collaborator

samuelcolvin commented Jun 28, 2024

E.g. queries like

select json_get(more_nested.json_data, more_nested.str_key1, more_nested.str_key2) v from more_nested

As of #22 this will return an error instead of silently only using the first array, but in theory we could fully support this.

Collaborator Author

samuelcolvin commented Jun 28, 2024 •

edited

Loading

You can work around this already by doing

select json_get(json_get(more_nested.json_data, more_nested.str_key1), more_nested.str_key2) v from more_nested

The automatic un-nesting added in #25 doesn't unnest this case.

samuelcolvin mentioned this issue

unnest json_get calls #25

Merged

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment