Say I have a function which returns an array. Can I access its items inline inside a select query? I can not use sub-querying since function relies on query parameters. And I can not declare outside variable for the same reason.
I expect somewhat like this:
select foo,bar, function(foo,bar) as array_item_1, function (foo,bar) as array_item_2 from table...
Currently I return function(foo,bar) as array_items and iterate it in application which is really cumbersome. I want db to return prepared outputs.