l></li>
</ul>
<h3 id="example-on-the-blogpost-db">Example on the blogpost DB</h3>
<figure>
<img src="../images/blogpost.png" alt="" /><figcaption>Blogpost DB</figcaption>
</figure>
<ul>
<li>We want to find all the replies to a given comment recursively
<ul>
<li>we don’t want only the direct replies, but also all the replies of the replies</li>
</ul></li>
<li>First attempt to retrieve only the direct replies:</li>
</ul>
<pre class="postgresql"><code>set search_path to blog3;
select comment_id, contents, re