Postgres - Change values before returning result set from a view

Question

I have a postgres view that returns records with either 'Y' or 'N' as the value, and I'd like to convert them to 'Yes' or 'No' before the final SQL results are returned. For instance:

    CREATE OR REPLACE VIEW transit_info AS 
 SELECT 
 ('Train Service:'::text || tblpoi_transit_info.train_service::text AS train_service,

I'd like to convert train_service to a 'Yes' or 'No' depending on the recorded value. Any way to do this easily? I've been experimenting with CASE statements but haven't really got the syntax down yet. Thanks.

Clodoaldo Neto · Accepted Answer · 2012-12-27 18:36:49Z

1

SELECT 
    ('Train Service:'::text
    ||
    case tblpoi_transit_info.train_service::text
        when 'Y' then 'Yes' else 'No'
    end AS train_service,

answered Dec 27, 2012 at 18:36

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

Collectives™ on Stack Overflow

Postgres - Change values before returning result set from a view

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related