<div class="highlight highlight-source-diff"><pre><span class="pl-md">--- a/lib/SQL/Translator/Producer/PostgreSQL.pm</span>
<span class="pl-mi1">+++ b/lib/SQL/Translator/Producer/PostgreSQL.pm</span>
<span class="pl-mdr">@@ -756,9 +756,13 @@</span> sub create_procedure {
   my @args = ();
   foreach my $arg (@{$procedure-&gt;parameters}) {
     $arg = {name =&gt; $arg} if ref($arg) ne 'HASH';
<span class="pl-md"><span class="pl-md">-</span>    push @args, join(' ', map $arg-&gt;{$_},</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>    my $param =  join(' ', map $arg-&gt;{$_},</span>
                           grep defined($arg-&gt;{$_}),
                           qw/argmode name type/);
<span class="pl-mi1"><span class="pl-mi1">+</span>    if( defined $arg-&gt;{ default } ) {</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>        $param .= ' default ' .$arg-&gt;{ default };</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>    }</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>    push @args, $param;</span>
   }
   $sql .= join(', ', @args);
   $sql .= ')';</pre></div>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/dbsrgits/sql-translator/issues/119?email_source=notifications&amp;email_token=AACJ4ATCRREO2SFYGM2MB3LP4ENIBA5CNFSM4H3BQZ2KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYN6NUA#issuecomment-505145040">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AACJ4ATVZGXFASRLZAKUT2LP4ENIBANCNFSM4H3BQZ2A">mute the thread</a>.<img src="https://github.com/notifications/beacon/AACJ4AWRRNT4B464K6Z3ZB3P4ENIBA5CNFSM4H3BQZ2KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYN6NUA.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/dbsrgits/sql-translator/issues/119?email_source=notifications\u0026email_token=AACJ4ATCRREO2SFYGM2MB3LP4ENIBA5CNFSM4H3BQZ2KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYN6NUA#issuecomment-505145040",
"url": "https://github.com/dbsrgits/sql-translator/issues/119?email_source=notifications\u0026email_token=AACJ4ATCRREO2SFYGM2MB3LP4ENIBA5CNFSM4H3BQZ2KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYN6NUA#issuecomment-505145040",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>