I create a function that returns the value of a field when the id is given :
CREATE OR REPLACE FUNCTION get_dcteam(id int) RETURNS text AS $$ #print_strict_params on DECLARE dc_team text; BEGIN SELECT monitoring_table.dc_team INTO STRICT dc_team FROM monitoring_table WHERE monitoring_table.id = get_dcteam.id; RETURN dc_team; END $$ LANGUAGE plpgsql;
I call it this way :
select * from get_dcteam((select id from monitoring_table where id=30))
What I want to do is call the function dynamically. I don't want to precise a known id.
How can I do this?