컴터/pgsql
문자 바꿈
우렁씨
2007. 10. 26. 14:19
http://database.sarang.net/?inc=read&aid=2671&criteria=pgsql&subcrit=&id=&limit=20&keyword=%B9%AE%C0%DA%BF%AD+%C7%D4%BC%F6&page=4
translate() 함수로 해결을 할 수 있을 듯싶습니다.
함수: translate(string text, from text, to text):
설명: text Any character in string that matches a character in the from set is replaced by the corresponding character in the to set.
예: translate('12345', '14', 'ax')
결과: a23x5