I am trying to implement the new out parameters in functions and stumbled upon a problem. There is an internal requirement for our databases that every function call always returns 2 params status & status_text. The problem now is that plpgsql selects the out params themselves into out params instead of function call results that i need there. If this is the expected behavior of out params it makes using out params a bit complicated if some table attributes happen to have the same name as out params. How can i overcome this situation? I can understand function variables having precedence over column names as you can freely rename them but out params is a different situation. snippet from code -[cut]-- out status int, -- 200 out status_text text -- OK ) AS $$ BEGIN -[cut]-- SELECT status, status_text FROM service._simple_add( i_key_user ,i_key_service ,i_action ,i_subscr_len) INTO status, status_text; -[cut]- Kristo Kaiv http://kaiv.wordpress.com (PostgreSQL blog) |
