I'm using the following query type quite a lot (joining a stored procedure to a table):
SELECT L.rPartijCnt FROM vkreg, LATERAL( GRN_PartijCreate(vkreg.siteid,vkreg.id,1) with (rSucces tinyint,rPartijCnt integer,rColliPerDc integer,rColliRest integer) ) L
But whenever I add an extra column to the result set of the procedure (GRN_PartijCreate) I have to change the queries using this procedure and add the new column to this "with" clause too (although I'm not intrested in the values)
Is there a way to use this procedure and only descripe the columns I actually want to use somehow (using sqlanywher 11 and up)?
thanks in advance
asked 01 Oct '16, 07:01
The docs state that
and your procedure call is a table-expression so you might simply use something like
to solve that problem. You might even be able to omit the WITH clause then, but note, I have not tested that.