create function string_to_json(varchar) returns json as $$
BEGIN
return $1::json;
EXCEPTION WHEN data_exception THEN
return '{}'::json;
END;
$$
LANGUAGE 'plpgsql';
可捕获的异常值 http://www.postgres.cn/docs/9.3/errcodes-appendix.html#ERRCODES-TABLE