Postgresql Select Constant

Name: Postgresql Select Constant
Uploaded: 2026-09-27T05:44:24+00:00
Duration: 11 min 23 s
Description: In Oracle I Can Select a Constant Value That Will Populate Down the Column Like This: Select "Constant" Constantvalue, Orders. Name from Orders and It Will...

Question

In Oracle I can select a constant value that will populate down the column like this:

Select 
     "constant" constantvalue,
     orders.name
from 
     orders

and it will yield:

ConstantValue     Name
  constant       sandwich
  constant        burger

For whatever reason, when I try to do this in postgres I receive this error.

ERROR:  column "Constant" does not exist

here is my 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

Accepted Answer

Change your double quotes to single quotes.

So this:

Select 
     "constant" as constantvalue,
     orders.name
from 
     orders

Should be this:

Select 
     'constant' as constantvalue,
     orders.name
from 
     orders

Answer 2

For anyone confused by @Adrian Lynch's answer, I found out that doing

SELECT
    'constant' AS ConstantValue,
    orders.name
FROM
    orders

did the trick for me.

This could be used for numbers as follows: 1234 AS constantvalue.

Postgresql Select Constant

2 Answers

Must Read

Your Answer

Marcus Vance

Postgresql Select Constant

2 Answers

Must Read

Your Answer

Sign up or log in

Post as a guest

Marcus Vance