Re: Regex for properly formed names - Mailing list pgsql-sql

From Erik Brandsberg
Subject Re: Regex for properly formed names
Date
Msg-id CAFcck8HJmvYm6r8cQ=QbPCH8yoQWa6sDUo71m5i=tQD4P_z-Dg@mail.gmail.com
Whole thread Raw
In response to Regex for properly formed names  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Pointing back to Karsen's comment, what IS the definition, and instead of asking "what is the regex" bring the question to a higher level, such as "How can I validate that an insert on a "name" field has all the words capitalized (but just the first word).  From a formal name perspective however, a name doesn't have all words capitalized, like "of" and "and" would be lower case.  It may be easier to implement different logic than a regex to do this.

On Mon, Oct 11, 2021 at 9:01 AM Shaozhong SHI <shishaozhong@gmail.com> wrote:
Hello,

What is the regex for properly formed names?

Scenario,

Bus Stop (St Peter's Church)

Scenario - wrongly formed name

Bus stop (st peter's church)

How to write a regex to detect wrongly formed names?

Regards,

David


--
Erik Brandsberg
erik@heimdalldata.com

www.heimdalldata.com
+1 (866) 433-2824 x 700
AWS Competency Program

pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: Regex for properly formed names
Next
From: aditya desai
Date:
Subject: Re: LISTEN / NOTIFY