Matt Andrews writes:
> Incidentally, I have become interested in the pg_node_tree type. I can't
> find much info on it. Would that be in the source? What would be the first
> steps for writing an extension for this sort of thing?
pg_node_tree is just a serialization of the tree-of-Node-structs
re
After thinking about this one for a while, I imagined even more nightmarish
scenarios than what you've just described here, and mapping the source
columns no longer seems like a viable idea.
Fortunately, there are a few work arounds I can rely on that particular to
our database design, which means
Matt Andrews writes:
> I'm trying to map view columns to their source columns using the system
> catalogs and information schema, but not having much luck. It's easy to
> determine which columns a view *depends *on, but not how those columns are
> mapped to the columns of the view. It seems like
t want to manipulate the
returned data based on the types/constraints of the underlying columns of
the view.
It seems like mapping view columns to their source columns should be
something that's been done before. Is it possible?
Matt Andrews
0400 990 131