* translate() [#fdaefe0a] ** 全角英数字を半角英数字へ変換する [#j8bae8bf] UPDATE t1 SET foo = translate(foo, '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ' ); ** 参考 [#uba5fa3f] http://www.postgresql.jp/document/9.1/html/functions-string.html