Re: SQL statement to set next serial value to max of a table?

Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> wrote:

>I want to execute the following two pseudo-SQL statements (that set the
>current value in a serial as the max of the primary key) as one SQL
>statement. What is the proper syntax?
>
>1- MAX = select max(id) from T;
>2- SELECT setval('T_id_seq', MAX);

either
SELECT setval( 'T_id_seq' , max(id) ) from T;
or
SELECT setval( 'T_id_seq' , (select max(id) from T) );
should do it

--
Rolf