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

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related