DevOps Articles

Understanding Recursive Queries in Postgres

Postgres provides us a way to write queries that are recursive in nature and fetch the data until the termination condition is met. This can be achieved using Common Table Expressions (CTEs). Using the WITH clause, we can create a temporary table scope of which is bound to that query itself.