title: PostgreSQL: I want to know the difference of 'cast'
body: <p>I try to convert mssql query to postgresql query.</p>
  
  <p>mssql query is</p>
  
  <pre><code>CONVERT(VARCHAR, column)
  </code></pre>
  
  <p>I know postgresql cast is two ways.</p>
  
  <p>1.</p>
  
  <pre><code>CAST(column as VARCHAR)
  </code></pre>
  
  <ol start="2">
  <li><p>column::VARCHAR</p></li>
  </ol>
  
  <p>What's the difference?</p>
  
  <p>Is it ok to use the second method?</p>