Postgresql Select Constant : <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>
