Function with OUT parameter and Return Query

From: Hector Menchaca <hm34306(at)hotmail(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Function with OUT parameter and Return Query
Date: 2014-10-05 04:23:47
Message-ID: BAY178-W3149BE50F365836CDC94EAF8A40@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

All,Struggling tying to get a function that works in Maraidb stored procs...looking to return an OUT Parameter value with Return Query
CREATE FUNCTION sp_AgentServer_Register (_agentserver_name TEXT, _port INTEGER, out _out_agent_server_id INTEGER) RETURNS SETOF AgentServerAS $$BEGIN Select _agent_server_id INTO _out_agent_server_id FROM sp_private_AgentServer_Insert(_agentserver_name, _port);
Update AgentServer SET RegisteredOn = NOW() where AgentServer_ID = _out_agent_server_id;
RETURN QUERY Select * From AgentServer where AgentServer_ID = _out_agent_server_id; END$$ LANGUAGE plpgsql;
In doing this an error is returned :ERROR: function result type must be integer because of OUT parameters
If I change to Integer, then I get an Error From the return query...ERROR: cannot use RETURN QUERY in a non-SETOF function
Is there a way to do this? (I'm assuming no at this point... i hoping there is some flag or something that I can set...)I can do this with MariaDB and SqlServer...
Any thoughts are appreciated.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Guillaume Lelarge 2014-10-05 08:06:04 Re: Function with OUT parameter and Return Query
Previous Message Dev Kumkar 2014-09-30 19:32:04 Re: [SQL] pg_multixact issues