<p class="MsoNormal"><span lang="EN-ZA">Hi all.</span><p class="MsoNormal"><span lang="EN-ZA">I am new to postgres, so
Iam still learning the basics.</span><p class="MsoNormal"><span lang="EN-ZA">In Sequel Server, one can set up a
functionto return a table eg:</span><p class="MsoNormal"><span lang="EN-ZA"> </span><p class="MsoNormal"><span
lang="EN-ZA">CREATEFUNCTION [dbo].[AuthCodes] (@CLIENTID INT)<span style=""> </span></span><p class="MsoNormal"><span
lang="EN-ZA">RETURNS@AuthCodes TABLE</span><p class="MsoNormal"><span lang="EN-ZA">(</span><p class="MsoNormal"><span
lang="EN-ZA"><spanstyle=""> </span>[ID] INT,</span><p class="MsoNormal"><span lang="EN-ZA"><span
style=""> </span>AUTHCODE VARCHAR(100),</span><p class="MsoNormal"><span lang="EN-ZA"><span
style=""> </span>ISSUEDATE DATETIME,</span><p class="MsoNormal"><span lang="EN-ZA"><span style="">
</span>ISSUEDBYVARCHAR(100),</span><p class="MsoNormal"><span lang="EN-ZA"><span style=""> </span>RECIPIENT
VARCHAR(100),</span><pclass="MsoNormal"><span lang="EN-ZA"><span style=""> </span>EMAILID VARCHAR(100)<span
style=""> </span></span><p class="MsoNormal"><span lang="EN-ZA">)</span><p class="MsoNormal"><span
lang="EN-ZA"> </span><pclass="MsoNormal"><span lang="EN-ZA">and then use select into or insert to populate the
table.</span><pclass="MsoNormal"><span lang="EN-ZA">I am really battling to figure out how to do the same in a postgres
function.</span><pclass="MsoNormal"><span lang="EN-ZA">It seems like one would have to create a user defined type
(myTypefor eg), and then set the return type of the function to be a set of myType, but I can’t seem to make it work. I
amguessing that I am on the wrong track…does anyone have any suggestions, or examples I could follow?</span>
