Re: plsql question

Поиск
Список
Период
Сортировка
От Bill Thoen
Тема Re: plsql question
Дата
Msg-id 4D559178.3080305@gisnet.com
обсуждение исходный текст
Ответ на plsql question  (Geoffrey Myers <lists@serioustechnology.com>)
Список pgsql-general
Дерево обсуждения
On 2/10/2011 6:40 PM, Geoffrey Myers wrote:
I am trying to write a plsql routine that will delete a range of characters based on their octal or hexadecimal values.  Something like the 'tr' shell command will do:

cat file| tr -d ['\177'-'\377']

Can't seem to figure this one out.

Pointers would be appreciated.

Would the string functions to_hex(), translate(), replace() and friends work for you?
(see http://www.postgresql.org/docs/9.0/static/functions-string.html)

В списке pgsql-general по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Schema version control
Следующее
От: David Kerr
Дата:
Сообщение: Re: pg_dump: schema with OID 58698 does not exist