i>use <code>comment_id = 1</code> instead of <code>reply_to_id = 1</code></li>
</ul></li>
<li><ul>
<li>If we need to include the comments starting with a blog post, we need a slightly different non-recursive term
<ul>
<li>use <code>blogpost_id = 1</code> instead of <code>reply_to_id = 1</code></li>
</ul></li>
</ul></li>
</ul>
<pre class="postgresql"><code>with recursive replies as (select comment_id, contents, reply_to_id, user_id
                           from comment
                           where blog