Hi,
now I'm using query:
select id, c1(my_func(id)), c2(my_func(id)) from my_table
my_table (
id int
)
my_table2 (
c1 int,
c2 int
)
my_function returns my_table2
but this quite inefficient because my_func is called twise for each row
Are there any possibilities to enhance this ?
Please reply to my e-mail too, because I'm not on the list
and mail archives are not functional at the moment
Thanks
Jan