title: pgsql stored procedure - internal, c or sql language is the best?
body: <p>I have a production pgsql server with the following stored procedure language support:</p>
  
  <ol>
  <li>internal</li>
  <li>c</li>
  <li>sql</li>
  </ol>
  
  <p>I cannot find examples for internal and c, just pl/pgsql or in rare cases sql. I'll try to get the provider to install other languages, but providers usually not provide, so I don't think this will happen... So I am stucked with these languages...</p>
  
  <p>Which one should I choose and why?
  (if you have a good tutorial too, then please write it in your answer or in comment)</p>
  
  <pre><code>select * from pg_language
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/zul78.png" alt="enter image description here"></p>
  
  <p>Btw I could not test the c and the internal without tutorial, so maybe there is a simple solution: I cannot use them because they are not trusted.</p>
  
  <p><strong>Edit - after the solution</strong></p>
  
  <p>The <code>create language</code> what worked for me. After that I checked what languages are available with the following query:</p>
  
  <pre><code>select * from pg_pltemplate
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/EuEMq.png" alt="enter image description here"></p>
  
  <p>You can read more about create language <a href="http://www.postgresql.org/docs/8.4/static/sql-createlanguage.html" rel="nofollow noreferrer">here</a>.</p>
  
  <p>I will use plpgsql, I found a good book about postgresql here: <a href="http://www.cis.temple.edu/~vasilis/Courses/CS33/Documentation/programmer.pdf" rel="nofollow noreferrer">The PostgreSQL Programmer's Guide , Edited by Thomas Lockhart</a></p>