Am 28.11.21 um 01:27 schrieb Shaozhong SHI:
this is supposed to find those to have 2 words and more.
select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+
]+[:alpha:]+$';
But, it finds only one word as well.
It appears that regex is not robust.
Can anyone shed light on this?
Rega
On 28/11/21 17:17, Godfrin, Philippe E wrote:
Right you are sir! I figured that out a few hours ago!
pg
*From:* Ron
*Sent:* Wednesday, November 24, 2021 10:58 PM
*To:* pgsql-general@lists.postgresql.org
*Subject:* [EXTERNAL] Re: Inserts and bad performance
On 11/24/21 1:15 PM, Godfrin, Phili
True but they're usually out-of-date.
On Sat, Nov 27, 2021 at 2:09 PM Chuck Davis wrote:
> Have you checked your distro repositories? The distro I use ships pgAdmin
> together with the latest and previous versions of postgresql.
>
> On Sat, Nov 27, 2021 at 10:52 AM Blake McBride
> wrote:
>
>>
On 2021-11-28 00:27:34 +, Shaozhong SHI wrote:
> It appears that regex is not robust.
It does reliably what you tell it to do.
I would agree that after almost 50 years of extending it, the syntax has
become a bit of a mess.
hp
--
_ | Peter J. Holzer| Story must make more se
On 2021-11-28 00:27:34 +, Shaozhong SHI wrote:
> this is supposed to find those to have 2 words and more.
>
> select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+ ]+[:alpha:]+$';
I think you meant
select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+ ]+[[:alpha:]]+$';
Note