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.johns...@gmail.com> a écrit : > On Fri, Nov 19, 2021 at 3:37 PM Abdul Mohammed <imonikemoham...@gmail.com> > 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. > >
