Skip to content
Opensource internals
  • Posts

Jsonpath

PostgreSQL's jsonpath Implementation in C

Aug 4, 2026 9 min read Jay Hubbert

When you write '$.a[*]'::jsonpath, the database does not store '$.a[*]'. It stores a flattened, linked list of compiled path nodes — and if you select the value back out, you get a …

PostgresInternalsJsonpath

Read more →

© 2026 Jay Hubbert · Built with Hugo 0.168.0

RSS ·