Hi,
Just one question
Isn't it possible to write a function that return an oid?
So.. One can write a function which create a temp table, feed it according to parameters and then return the oid of the created temp table.
No??
Le ven. 19 nov. 2021 à 23:48, David G. Johnston <david.g.johnston@xxxxxxxxx> a écrit :
On Fri, Nov 19, 2021 at 3:37 PM Abdul Mohammed <imonikemohammed@xxxxxxxxx> wrote:I read somewhere that you could have a table as a return type. I, therefore tried using the pivot table alias as the return type but got an error along lines of the alias not being recognized.A table in that context is something you create using the "Create table" command. And, per my other comments, you have to have done this before even creating the function in question since the function has to point to the table during the "create function" command's execution.David J.
