Re: Regex for properly formed names

On Mon, Oct 11, 2021, 6:15 AM Metin Ulusinan <metin.ulusinan@ssicilian.net>
wrote:

> If regex is not necessary;
>
> INITCAP(bus_stop_name) != bus_stop_name
>
> can be answer? 😎
>
>
>
> On Mon, Oct 11, 2021 at 4:01 PM 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
>>
>
If the regex definition is a space followed by a lower case letter or a
lower case letter at the start of the string, I haven't tested this (on my
phone) but /(^[a-z])|(\s[a-z])/

Some regex flavors don't like | as 'or' so you'd want to figure that out..
I'm not sure about postgres.

Steve