title: How can I generate a series of repeating numbers in PostgreSQL?
body: <p>In PostgreSQL, is it possible to generate a series of repeating numbers? For example, I want to generate the numbers 1 to 10, with each number repeated 3 times:</p>
  
  <pre><code>1
  1
  1
  2
  2
  2
  3
  3
  3
  .. and so on.
  </code></pre>