postgresql 字符串转整形

字符串转Integer

SELECT CAST (title as integer)

  FROM xxx where code='-1';

 

转整形加一

update xxx set  title = (CAST (title as integer)+1) where code='-1';