Postgres Pro
Downloads
Home   >   mailing lists

Thread: [HACKERS] Access inside pg_node_tree from query?

[HACKERS] Access inside pg_node_tree from query?

From
Ryan Murphy
Date:
Hi Postgressers,

Quick question, just curious - is there a way to access the members of a `pg_node_tree` value within a Postgres query?  By pg_node_tree I mean for example, the `ev_qual` field in the `pg_rewrite` table.  By "access the members" I mean in the same way that you can access the members of a json or jsonp value (using -> or ->>).  Is there anything analogous for pg_node_tree?

Thanks!
Ryan

Re: [HACKERS] Access inside pg_node_tree from query?

From
Michael Paquier
Date:
On Sat, Feb 11, 2017 at 7:19 PM, Ryan Murphy <ryanfmurphy@gmail.com> wrote:
> Quick question, just curious - is there a way to access the members of a
> `pg_node_tree` value within a Postgres query?  By pg_node_tree I mean for
> example, the `ev_qual` field in the `pg_rewrite` table.  By "access the
> members" I mean in the same way that you can access the members of a json or
> jsonp value (using -> or ->>).  Is there anything analogous for
> pg_node_tree?

There are no in-core operators or functions to manipulate pg_node_tree.
-- 
Michael

Re: [HACKERS] Access inside pg_node_tree from query?

From
Ryan Murphy
Date:


There are no in-core operators or functions to manipulate pg_node_tree.

Thanks Michael, just checking!