Обсуждение: [HACKERS] Access inside pg_node_tree from query?

Поиск
Список
Период
Сортировка

[HACKERS] Access inside pg_node_tree from query?

От
Ryan Murphy
Дата:
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?

От
Michael Paquier
Дата:
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?

От
Ryan Murphy
Дата:


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

Thanks Michael, just checking!