--- On Mon, 10/20/08, pere roca <[EMAIL PROTECTED]> wrote:
> From: pere roca <[EMAIL PROTECTED]>
> Subject: re[GENERAL] moving a portion of text
> To: pgsql-general@postgresql.org
> Date: Monday, October 20, 2008, 11:21 AM
> hi,
> I have a column with fu
On Mon, Oct 20, 2008 at 04:21:31AM -0700, pere roca wrote:
> I have a column with full of data like ATB-OO NCK-TT how can I
> easily remove the "-" ?
If you just want to remove all the dashes then I'd use a regex;
something like:
UPDATE table SET data = regexp_replace(data, '-', '', 'g'
hi,
I have a column with full of data like ATB-OO NCK-TT how can I
easily remove the "-" ? it seems that the "-" is allways the fourth letter.
thanks,
Pere
--
View this message in context:
http://www.nabble.com/removing-a-portion-of-text-tp20067248p20067248.html
Sent from the Postg
