Re: Postgres / plpgsql equivalent to python's getattr() ?

On Wed, 2011-08-03 at 18:48 -0400, Tom Lane wrote:
> James Robinson <jlrobins(at)socialserve(dot)com> writes:
> > Python's getattr() allows for dynamic lookup of attributes on an
> > object, as in:
>
> > inst = MyClass(x=12, y=24)
> > v = getattr(inst, 'x')
> > assert v == 12
>
> > Oftentimes in writing data validating trigger functions, it'd be real
> > handy to be able to do a similar thing in plpgsql
>
> > Is there something in the internals which inherently prevent this?
>
> plpgsql is strongly typed (much more so than python, anyway).

For example the plpgsql type RECORD is about as strongly typed as (some)
python classes , that is once assigned the record itself is typed, but
the same variable can point to different record types

--
-------
Hannu Krosing
PostgreSQL Infinite Scalability and Performance Consultant
PG Admin Book: http://www.2ndQuadrant.com/books/