Need help to dynamically access to colomns in function! - Mailing list pgsql-general

From Иван Марков
Subject Need help to dynamically access to colomns in function!
Date
Msg-id 5b9f5ce70812161237j2c0cda12l2b35346a5101a2ba@mail.gmail.com
Whole thread Raw
Responses Re: Need help to dynamically access to colomns in function!
Re: Need help to dynamically access to colomns in function!
List pgsql-general
Hello. I have table classif with columns:
... , group1, group2, group3, ... , group48, ...

In function i do query and want run on every row and dynamically operate on columns from group1 to group20. I do something like this:

OPEN curs FOR select * from classif;
 loop
    fetch curs into tmprec;
    exit when not found;
   
    for I in 1..20 loop
        ...
    -- problem code is:
        value := tmprec.group{I}; 
    -- i cannot dynamically access to group1, group2, ... colomns according to "I" variable.
    ...   

    end loop;
end loop;

I have to manually identify and handle each entry without a cycle do something like this:
value := tmprec.group1;
...
value := tmprec.group2;
...
value := tmprec.group2;
...
value := tmprec.group20;
   
Please help me to do it dynamically with a loop, depending on the I?
something like this in a loop:
value := tmprec.group{I}; 

Thanks.

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Isolating a record column from a PL-Pgsql function call ?
Next
From: "Gauthier, Dave"
Date:
Subject: Re: Isolating a record column from a PL-Pgsql function call ?