Ioana Danes wrote
> create view tmp_view as
> with func as (
> select tmp_Cashdrawer.CashdrawerID, test1(tmp_Cashdrawer.CashdrawerID)
> as call
> from tmp_Cashdrawer
> )
> select func.CashdrawerID, (func.call).*
> from func;
So yeah, putting this into a view will not work. The WITH/CTE c
Ioana Danes wrote
>
> If I will have to filter the tmp_Cashdrawer table then it executes the
> function for the all the cash drawers and then filter out the result which
> again is not efficient...
Hm
SELECT function_call(...)
FROM tbl
WHERE tbl.pk = ...;
That should only cause function
Ioana Danes wrote
>
> If I will have to filter the tmp_Cashdrawer table then it executes the
> function for the all the cash drawers and then filter out the result which
> again is not efficient...
Hm
SELECT function_call(...)
FROM tbl
WHERE tbl.pk = ...;
That should only cause function_ca
Ioana Danes wrote
> Hi All,
> Is there any similar syntax that only invokes the procedure once and
> returns all the columns?
Generic, adapt to fit your needs.
WITH func_call AS (
SELECT function_call(...) AS func_out_col
)
SELECT (func_out_col).*
FROM func_call;
Basically you have to execut
Ioana Danes wrote
> Hi All,
> Is there any similar syntax that only invokes the procedure once and
> returns all the columns?
Generic, adapt to fit your needs.
WITH func_call AS (
SELECT function_call(...) AS func_out_col
)
SELECT (func_out_col).*
FROM func_call;
Basically you have to execute t
