Re: Robust ways for checking allowed values in a column

On Tue, Jan 25, 2022 at 6:56 AM Shaozhong SHI <shishaozhong(at)gmail(dot)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.