Access inside pg_node_tree from query?

Started by Ryan Murphyalmost 9 years ago3 messages
#1Ryan Murphy
ryanfmurphy@gmail.com

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

#2Michael Paquier
michael.paquier@gmail.com
In reply to: Ryan Murphy (#1)
Re: Access inside pg_node_tree from query?

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#3Ryan Murphy
ryanfmurphy@gmail.com
In reply to: Michael Paquier (#2)
Re: Access inside pg_node_tree from query?

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

Thanks Michael, just checking!