Home / Companies / Hasura / Blog / Post Details
Content Deep Dive

Query hierarchical data structures on Hasura with Postgres ltree

Blog post from Hasura

Post Details
Company
Date Published
Author
Abby Sassel
Word Count
889
Company Posts That Month
19
Language
English
Hacker News Points
-
Post removed?
No
Summary

This post introduces support in Hasura 2.0 for queries on hierarchical data structures using Postgres ltree operators. Ltree is a Postgres extension that enables powerful search functionality and can be used to model, query, and validate hierarchical and arbitrarily nested data structures. The newly supported ltree comparison operators include _ancestor, _descendant, _matches, _matches_fulltext, and their *_any variants. These operators allow for efficient querying of hierarchical data in Hasura applications.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.