title: Postgresql Select Constant
body: <p>In Oracle I can select a constant value that will populate down the column like this:</p>
  
  <pre><code>Select 
       "constant" constantvalue,
       orders.name
  from 
       orders
  </code></pre>
  
  <p>and it will yield:</p>
  
  <pre><code>ConstantValue     Name
    constant       sandwich
    constant        burger
  </code></pre>
  
  <p>For whatever reason, when I try to do this in postgres I receive this error.</p>
  
  <pre><code>ERROR:  column "Constant" does not exist
  </code></pre>
  
  <p>here is my code </p>
  
  <pre><code>    select
          date_trunc('day', measurement_date + (interval '1 day' * (6 - extract(dow from measurement_date)))) week,
          "AROutstanding" colname,
          round(avg(Total_Outstanding),0) numbah
      from
                  (
                  select
                      measurement_date,
  
                      sum(cast(sum_of_dollars as numeric)) Total_Outstanding
                  from
                      stock_metrics
                  where
                      invoice_status not in  ('F','Write off')
                  group by
                      measurement_date
                  ) tt
              group by
                  week
  </code></pre>