Mike_Knight: ok, so that is i don't want ;) i want it like above "SELECT FUNC_NAME() FROM rfm_meas WHERE ..." thats not possible? if i use it like u mean, i always hafe to get all data of a row (because of SELECT *)? is that a god idea for the performance?
that might be several houndred MBs
oops ... ok .. now i get it
with select * i select the returned values from the function only !?
Mike_Knight: better like this http://pgsql.privatepaste.com/401a863b90
? now I need "only" a suitable loop from line 6-11 and a working sql-select-clause (line 8)
Mike_Knight: ... i switched the order of into/from ... the problem is: Error(2,10): PLS-00630: pipelined functions must have a supported collection return type
Mike_Knight: okay ... i made it without pipelined-function
Mike_Knight: no, that dont work either o_O
because the funtion dont uses only the rows affected by the parent sql-query
i'll paste it
here we go: http://pgsql.privatepaste.com/c6d648f515
i have to give the (explicit) cursor from the select-statement as a parameter to the function? no other way?
i'm still stuck with that problem ... don't find a solution after 2hours o_O .. will have a lunch now ... feel free to help ;)