xtdb 2024-07-14 | Slack Archive

🙋 Hi, in v2, how should I reference a nested object key/property in a select? 🧵

For example, after this insert:

INSERT INTO locations (_id, owner)
VALUES (1, {id: 'foo'})

This select doesn’t return what I’d hoped:

SELECT _id, owner.id
FROM locations

it returns only:

| _id |
|-----|
| 1   |

What am I missing? Are there any docs where I could have looked this up? I did try searching, I promise...

Thanks! Is that written anywhere in the docs?

2024-07-14