postgresql中在查询结果中将字符串转换为整形或浮点型

string转integer

 

string转float

 

select '23.3'::float as result

integer转string

select 23::Text as result