Re: Removing terminal period from varchar string in table column

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Removing terminal period from varchar string in table column
Дата
Msg-id CAA-aLv65ZezBo8AM29dPJK6-THmqMsfr2WdiETbwag29DmhQnQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Removing terminal period from varchar string in table column  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Removing terminal period from varchar string in table column
Список pgsql-general
Дерево обсуждения
On Tue, 15 Jul 2025, 18:59 Rich Shepard, <rshepard@appl-ecosys.com> wrote:
On Tue, 15 Jul 2025, Thom Brown wrote:

> There are various options, but perhaps just use rtrim.
> rtrim(company_name, '.')

Thom,

I looked at rtrim() but didn't see where to specify the table name. Would it
be `select * from table companies rtrim(company_name, '.')'?

UPDATE companies
SET company_name = rtrim(company_name, '.')
WHERE company_name != rtrim(company_name, '.');

Thom

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