Hey,
2011/2/16 arthur_info
>
> Hello,
>
> I've got the following function and I want to access the fields values of
> my
> record by index. The problem is that my select is retrieving each record
> line with all values and not each one of each row on my view... How can I
> solve this problem?
>
Στις Wednesday 16 February 2011 18:18:19 ο/η arthur_info έγραψε:
>
> Hello,
>
> I've got the following function and I want to access the fields values of my
> record by index. The problem is that my select is retrieving each record
> line with all values and not each one of each row on my view...
Hello
you can't simply iterate over record in plpgsql. You can use a some
toolkits like PLToolkit, or different PL language like PLPerl, or some
dirty trick
http://okbob.blogspot.com/2010/12/iteration-over-record-in-plpgsql.html
regards
Pavel Stehule
2011/2/16 arthur_info :
>
> Hello,
>
> I've
Hello,
I've got the following function and I want to access the fields values of my
record by index. The problem is that my select is retrieving each record
line with all values and not each one of each row on my view... How can I
solve this problem?
Thanks in advance.
CREATE FUNCTION fc_test
Hello,
I've got the following function and I want to access the fields values of my
record by index. The problem is that my select is retrieving each record
line with all values and not each one of each row on my view... How can I
solve this problem?
Thanks in advance.
CREATE FUNCTION fc_test
