postgres select non existing field as empty string

Question

This might be a stupid question. Imaging following table in Postgres:

create table scientist (id integer, firstname varchar(100), lastname varchar(100));
insert into scientist (id, firstname, lastname) values (1, 'albert', 'einstein');

A simple select of all fields:

select  id, firstname, lastname   scientist;

results in:

is	firstname	lastname
1	albert	einstein

Is there some way to add a kind of non-existing empty virtual field f.e. age? Pseudo Code:

 select 
    id, 
    firstname, 
    lastname,
    age as '' -- my non existing field that should show up in the results
    from 
    scientist;

that the result looks like?

is	firstname	lastname	age
1	albert	einstein

user330315 · Accepted Answer · 2022-02-09 22:20:38Z

4

It's the other way round: as defines a column alias, so

'' as age

will work.

However, I'd be quite surprised about a column named age in a result that is a character value, not an integer. If you want a typed value, you can also use null::int as age

answered Feb 9, 2022 at 22:20

user330315

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

Collectives™ on Stack Overflow

postgres select non existing field as empty string

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