Try
Home   >   mailing lists

Re: Removing terminal period from varchar string in table column - Mailing list pgsql-general

From Rich Shepard
Subject Re: Removing terminal period from varchar string in table column
Date
Msg-id 8f5b6f90-cbb7-bffc-c15-134dcc6bce4@appl-ecosys.com
Whole thread Raw
In response to Re: Removing terminal period from varchar string in table column  (Thom Brown <thom@linux.com>)
Responses Re: Removing terminal period from varchar string in table column
List pgsql-general
Tree view 
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, '.')'?

Thanks,

Rich

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Removing terminal period from varchar string in table column
Next
From: Rich Shepard
Date:
Subject: Re: Removing terminal period from varchar string in table column