[d2rq-dev] Using stored procedures with d2rq

[<dan...@es...>]

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