Select in return for postgres query

Question

is it possible to add a select in a return statement?

insert into user_skills_languages 
(
  user_id, 
  skill_id,
  skill_type_id
)
values(
  213,
  1,
  0
)
returning skill_id, skill_type_id, select name from skills where skill_id = 1

I tried adding the select name from skills where skill_id = 1 but not sure if this is possible or I just don't have the syntax right.

Laurenz Albe · Accepted Answer · 2020-10-31 04:47:16Z

2

Yes, that is possible, but you have to enclose a subquery in parentheses:

RETURNING skill_id,
          skill_type_id,
          (SELECT name FROM skills WHERE skill_id = 1)

answered Oct 31, 2020 at 4:47

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

Select in return for postgres query

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