Re: underscore
От
Steve Crawford
Тема
Re: underscore
Дата
Msg-id
20030130161124.5C4A2103EF@polaris.pinpointresearch.com
Ответ на
Re: underscore (ryanne cruz)
Список
Дерево обсуждения
Re: underscore ryanne cruz <ryanne.cruz@up.edu.ph>
Re: underscore Matthew Horoschun <mhoroschun@canprint.com.au>
Re: underscore "scott.marlowe" <scott.marlowe@ihs.com>
Re: underscore Steve Crawford <scrawford@pinpointresearch.com>
try translate():
select translate('Mary Margaret Smith',' ','_');
translate
---------------------
Mary_Margaret_Smith
Cheers,
Steve
On Wednesday 29 January 2003 9:09 pm, ryanne cruz wrote:
> hi list!
>
> i have a column wherein a lot of entries has 2 or more names int it. these
> are separated by spaces. an example is: "John Doe", "Mary Margaret Smith".
> i need to replace the spaces with an underscore. any idea how to do this?
>
> thanks!
>
> ryanne
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
В списке pgsql-php по дате отправления
