On 22/11/17 09:36, Brahmam Eswar wrote:
we are in process of migrating to postgres and need to reset the sequence number with highest value of table key . I want to make it procedural to do that as mentioned below,But it's throwing an error .DO $$ DECLARE SEQ BIGINT; BEGIN SEQ:=(SELECT MAX(ID) FROM TABLE_1);
select max(id) into seq from table_1; Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie