Can i get a counter value and update in single query

SQL++
2 
update default 
set next_batch = next_batch + 1 
where _type ='cname_info'   
RETURNING next_batch - 1;

returns updated value. If you want pre-value decrement by 1 in RETURNING clause as mentioned above