Skip to content

Instantly share code, notes, and snippets.

@mirzap

mirzap/gist:a12ff04472d49e2aa45d965a727e93d6

Forked from robertsosinski/gist:1123254
Created September 30, 2021 15:57
Show Gist options
  • Save mirzap/a12ff04472d49e2aa45d965a727e93d6 to your computer and use it in GitHub Desktop.
Save mirzap/a12ff04472d49e2aa45d965a727e93d6 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Robert Sosinski created this gist Aug 3, 2011.
    10 changes: 10 additions & 0 deletions gistfile1.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,10 @@
    with recursive breadcrumbs(id, parent_id, name) as (
    select id, parent_id, name
    from pages
    where id = 4
    union
    select p.id, p.parent_id, p.name
    from pages p
    inner join breadcrumbs b on p.id = b.parent_id
    )
    select * from breadcrumbs;