Need help to dynamically access to colomns in function!

Поиск
Список
Период
Сортировка
От Иван Марков
Тема Need help to dynamically access to colomns in function!
Дата
Msg-id 5b9f5ce70812161237j2c0cda12l2b35346a5101a2ba@mail.gmail.com
обсуждение исходный текст
Ответы Re: Need help to dynamically access to colomns in function!  (Sam Mason <sam@samason.me.uk>)
Re: Need help to dynamically access to colomns in function!  (David Fetter <david@fetter.org>)
Список 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 по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Isolating a record column from a PL-Pgsql function call ?
Следующее
От: "Gauthier, Dave"
Дата:
Сообщение: Re: Isolating a record column from a PL-Pgsql function call ?