need a function to extract list items from pg_node_tree

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: need a function to extract list items from pg_node_tree
Date: 2012-12-21 12:20:00
Message-ID: 1356092400.25658.6.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In order to implement the PARAMETER_DEFAULT column in the information
schema I need a way to get the expressions out of the proargdefaults
column. pg_get_expr(proargdefaults, 0) gives me all expressions
comma-separated, but I need them individually. I think a function like
pg_get_list_nth (to keep consistent with the internal list API) could
work. Alternatively, a list-to-array function might do the trick. Are
there are any other potential uses cases that should be considered here?
AFAICT, indexprs is the only other system catalog column that contains
an expression list.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2012-12-21 12:26:32 Re: need a function to extract list items from pg_node_tree
Previous Message Dean Rasheed 2012-12-21 10:04:36 Re: Review of Row Level Security