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

On Wed, 2011-08-03 at 18:48 -0400, Tom Lane wrote:
> James Robinson  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/