subquery in postgres

Question

insert into nt_nurture_profile (credit,user_id,wallet_key)
values (0, select person_id from ct_student where person_id not in(select user_id from nt_nurture_profile), gen_random_uuid ());

this is my code but ran into an error

syntax error at or near "select"

but when i use select in single line it works!

Ftisiot · Accepted Answer · 2021-08-09 11:50:38Z

1

The below select statements works

insert into nt_nurture_profile (credit,user_id,wallet_key)
select 0, person_id, gen_random_uuid ()
  from ct_student 
  where person_id not in(select user_id from nt_nurture_profile));

edited Aug 9, 2021 at 11:50

answered Aug 9, 2021 at 8:31

Ftisiot

1,8981 gold badge9 silver badges14 bronze badges

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

2 Comments

Gordon Linoff Over a year ago

If by "fill all the values manually" you mean that VALUES does not support subqueries, then this answer is wrong (although the code portion is fine).

Ftisiot Over a year ago

Correct, I reworded the reply

Collectives™ on Stack Overflow

subquery in postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related