public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rich Shepard <[email protected]>
To: [email protected]
Subject: Re: Removing terminal period from varchar string in table column
Date: Tue, 15 Jul 2025 13:15:11 -0700 (PDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAA-aLv65ZezBo8AM29dPJK6-THmqMsfr2WdiETbwag29DmhQnQ@mail.gmail.com>
References: <[email protected]>
	<CAA-aLv4cHmb=0aYm72z=HT93NR6=L8uHVTB92siQONX+7QT6yg@mail.gmail.com>
	<[email protected]>
	<CAA-aLv65ZezBo8AM29dPJK6-THmqMsfr2WdiETbwag29DmhQnQ@mail.gmail.com>

On Tue, 15 Jul 2025, Thom Brown wrote:

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

Thom,

That makes sense. The web pages I read assumed I knew to use the UPDATE
command. As this was the first time I needed to clean column content I
didn't assume that update was the appropriate mechanism. Now I do.

Thanks,

Rich

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Removing terminal period from varchar string in table column
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox