Kevin Duffy wrote:
> Noticed that string_to_array does not handle double spaces very well.
> If there are double space between the tokens, there is "" (empty string)
> in the array returned. Not exactly what I expected.
Try regexp_replace
http://www.postgresql.org/docs/8.3/interactive/functions-string.html