Home > mailing lists

Re: plsql question - Mailing list pgsql-general

From	Bill Thoen
Subject	Re: plsql question
Date	February 11, 2011 18:43:48
Msg-id	4D559178.3080305@gisnet.com Whole thread Raw
In response to	plsql question (Geoffrey Myers <lists@serioustechnology.com>)
List	pgsql-general

Tree view

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 by date:

From: Bill Moran
Date: 11 February 2011, 14:11:47
Subject: Re: Schema version control

From: David Kerr
Date: 11 February 2011, 18:52:58
Subject: Re: pg_dump: schema with OID 58698 does not exist

Re: plsql question - Mailing list pgsql-general

Previous

Next