Hi all,
I've been trying to map the results of a stored procedure instead
of tables. I've tried using the "SQLExpression" tag, but I wasn't
able to get anything. Is it supposed to work? In this case I should
be doing something wrong, of is there anything prepared for that?
For more details, the stored procedure I'm trying to map is the
next one (as I query for it in the database):
get_traceroutes(ARRAY['agent_id', 'destination_id', 'first',
'last', 'hops', 'hop_count', 'tool_id'], 'agent_id = 11824 AND
destination_id = 1416 AND hop_count > 20','2012-09-09
14:30:09','2012-09-13 14:30:09') AS foo(agent_id integer,
destination_id integer, first timestamp without time zone, last
timestamp without time zone, hops ip_hop_t[], hop_count integer,
tool_id integer))
Thank you in advance.
Best regards, Daniel
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
