Re: [GENERAL] access computed field of RECORD variable

2010-01-11 Thread Steve White
Alvaro, I followed your advice, but using PL/Python. I succeeded, but only with great difficulty. To close this off, I'll write these down, together with the work-arounds. Some of this info would be of use if it were in the documentation. Problems 1) (documentation) The doc says P

Re: [GENERAL] access computed field of RECORD variable

2010-01-05 Thread Steve White
Merlin, There is a set of databases whose columns are differently named and have different meanings, but which are processed similarly (the data is all floats, and some dot products need to be made). The processing to be done can all described by other tables which provide coefficents based on the

Re: [GENERAL] access computed field of RECORD variable

2010-01-05 Thread Merlin Moncure
On Tue, Jan 5, 2010 at 8:53 AM, Steve White wrote: > Hi, > > I ran into a roadblock at the very bottom of a fairly large database > design implementation.  It will be at least messy to fix, unless there is > a neat solution. > > The roadblock is: > > There is a record, which may be from any of a s

Re: [GENERAL] access computed field of RECORD variable

2010-01-05 Thread Alvaro Herrera
Steve White wrote: > The roadblock is: > > There is a record, which may be from any of a set of similar databases. > Field names for this record are computed as strings. Using these strings, > I need to access fields of the record. > > But I can't find the syntax for it. You can't do this wi