Hi!
I'd like to ask whether it is possible to access fields of record type variable in plpgsql in the following way:
I have a table with field named "XY_1", "XY_2", ... "XY_255".
I want to access the values in the table from a plpgsql function somehow in a loop with the iterative variable. Can I address the appropriate ''XY_'' || loopvariable field with the help of the loop variable?
If I can, what is the syntax of this? Sorry, I've read through the documentation, but haven't find any solution.
I have thought of an alternative solution: can plpgsql convert a record type into array? (Then I could address the field value with the nth element of the array)
Thanks for your help
tomasz
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
