sql根据字段生成主键

select s.pre::numeric+s.row,test.*
from test left join 
(
select to_char(now(),'yyyyMMddmmss000') pre,row_number() over(order by c1,c2,c3,c4,c5) row,c1||c2||c3||c4||c5 as t1 from test
group by c1,c2,c3,c4,c5

) s on
c1||c2||c3||c4||c5=s.t1