Re: remove too much space between words of the string

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Akbar <melinda_sayang(at)hotpop(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: remove too much space between words of the string
Date: 2004-12-01 14:49:44
Message-ID: 20041201144944.GB22749@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Dec 01, 2004 at 18:18:41 +0700,
Akbar <melinda_sayang(at)hotpop(dot)com> wrote:
> Assume I have this string: 'bla bla'. Is there any
> function to make that string to become: 'bla bla'. Or do I have to make
> the function manually???

You need to write a function to do this.

Usually I do this kind of processing before trying to store the data in
the database and use a constraint to enforce that there aren't
consecutive blanks.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Robert Wimmer 2004-12-01 16:56:04 catch runtime errors
Previous Message Akbar 2004-12-01 11:18:41 remove too much space between words of the string