Re: variables with SELECT statement - Mailing list pgsql-sql

From Frank Bax
Subject Re: variables with SELECT statement
Date
Msg-id 48C19A24.90203@sympatico.ca
Whole thread Raw
In response to Re: variables with SELECT statement  ("Kevin Duffy" <KD@wrinvestments.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Kevin Duffy"
Date:
Subject: Re: variables with SELECT statement
Next
From: "Kevin Duffy"
Date:
Subject: Re: variables with SELECT statement