Search Postgresql Archives

Re: Execute command in PL/pgSQL function not executing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux