Re: Removing terminal period from varchar string in table column

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Removing terminal period from varchar string in table column
Дата
Msg-id 512c9d0-442d-5bb4-bd26-6b7d222c8235@appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Removing terminal period from varchar string in table column  (Jeff Ross <jross@openvistas.net>)
Список pgsql-general
On Tue, 15 Jul 2025, Jeff Ross wrote:

> How about
>
> test:
>     select company_name, replace(company_name,'.','') from companies;
>
> update:
>     update companies set company_name = replace(company_name,'.','') where 
> company_name like '%.';

Jeff,

These contain the table and column names I didn't see in web page examples.
Using update looks better to me.

Many thanks,

Rich



В списке pgsql-general по дате отправления: