Fetches all fields of all ancestors for the node 267 (works only with postgresql)

ancestors.sql

WITH RECURSIVE ezcontentobject_ancestors(node_id, parent_node_id) AS (

    SELECT node_id, parent_node_id
    FROM ezcontentobject_tree
    WHERE parent_node_id > 0
  UNION 
    SELECT parents.node_id, ancestors.parent_node_id
    FROM ezcontentobject_tree as parents, ezcontentobject_ancestors as ancestors
    WHERE parents.parent_node_id = ancestors.node_id

), ancestors AS (
    SELECT * FROM ezcontentobject_ancestors
)

SELECT parents.*
FROM ezcontentobject_tree as parents, ancestors
WHERE parents.node_id = ancestors.parent_node_id and ancestors.node_id = 267