How to set a value to sequence?

Question

How to set value to sequence in plpgsql ?

This fails in plpgsql

select setval('public.student_id', select max(student_id) from public.student);

@LaurenzAlbe, you are correct, it is possible to use a subquery. As you point out in your answer it just needs to be surrounded by parentheses, so: `select setval('public.student_id', (select max(student_id) from public.student));` — Adrian Klaver, May 10 '21 at 14:54

score 0 · Answer 1 · answered May 09 '21 at 17:40

0

you can do this instead, imagining public.student_id is the name of sequence that already exists:

select setval('public.student_id',max(student_id))
from public.student;

answered May 09 '21 at 17:40

eshirvana

score 0 · Answer 2 · answered May 10 '21 at 05:16

0

All you have to do is surround the subquery with parentheses. That is syntactically required.

answered May 10 '21 at 05:16

Laurenz Albe

2 Answers2