Re: Postgres / plpgsql equivalent to python's getattr() ? - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Postgres / plpgsql equivalent to python's getattr() ?
Date
Msg-id 1312466425.4917.21.camel@hvost
Whole thread Raw
In response to Re: Postgres / plpgsql equivalent to python's getattr() ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, 2011-08-03 at 18:48 -0400, Tom Lane wrote:
> James Robinson <jlrobins@socialserve.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/



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https
Next
From: James Robinson
Date:
Subject: Re: Postgres / plpgsql equivalent to python's getattr() ?