PostgreSQL view column naming

Question

I'm trying to name a new column in my view... here is (part of) my code:

SELECT co_url_name, score_combined,(SELECT trunc(("productAndServices" + "futurePurchase" + shipping + "customerService" + returns + "lifetimeRating")/6, 2) AS resellerRating)

Basically it's just an average of a bunch of columns.

However, the column comes up named ?column? instead and was wondering how I need to change my syntax to name the column resellerRating instead.

I tried ALTER VIEW myview RENAME COLUMN "?column?" TO resellerRating; and not surprisingly got an error.... can anyone help me figure this out?

Eric · Accepted Answer · 2012-01-03 19:24:15Z

1

Change your view definition to this:

SELECT 
    co_url_name, 
    score_combined,
    (SELECT trunc(("productAndServices" + "futurePurchase" + shipping + "customerService" + returns + "lifetimeRating")/6, 2)) AS resellerRating

If you want to post your whole query here, I can refactor it, but as it were, you need to put the alias outside the subquery.

answered Jan 3, 2012 at 19:24

Eric

95.7k13 gold badges117 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tnw Over a year ago

I appreciate the offer, but this answers my question perfectly. I'll accept your answer soon as I can! Thank you!

Collectives™ on Stack Overflow

PostgreSQL view column naming

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related