Re: Robust ways for checking allowed values in a column - Mailing list pgsql-general

From David G. Johnston
Subject Re: Robust ways for checking allowed values in a column
Date
Msg-id CAKFQuwbhKUsPXwPvoPnh2Xv=g748y6UxigCOoNOUY=a7EhEv0Q@mail.gmail.com
Whole thread Raw
In response to Robust ways for checking allowed values in a column  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses Re: Robust ways for checking allowed values in a column  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-general
On Tue, Jan 25, 2022 at 6:56 AM Shaozhong SHI <shishaozhong@gmail.com> wrote:
 select form from mytable  where form ~ '^Canal$|^Drain$|^Foreshore$|^inlandRiver$|^Lake$|^lockOrFlightOfLocks$|^Marsh$|^Researvoir$|^Sea$|^tidalRiver$|^Transfer$'

You do not need to repeat the boundary metacharacters on each branch.  You can assert their presence just once and then use parentheses to group the alternations.

form ~ '^(?Canal|Drain|etc...)$'

David J.

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Robust ways for checking allowed values in a column
Next
From: Ray O'Donnell
Date:
Subject: Re: Robust ways for checking allowed values in a column