Re: Robust ways for checking allowed values in a column

On 25/01/2022 13:55, Shaozhong SHI wrote:
> I tried the following:
> 
> select form from mytable  where form ~ 
>
'^Canal$|^Drain$|^Foreshore$|^inlandRiver$|^Lake$|^lockOrFlightOfLocks$|^Marsh$|^Researvoir$|^Sea$|^tidalRiver$|^Transfer$'
>
>  I used ^ and $ to ensure checking of allowed values.
> 
> However, 'Backyard' was selected.
> 
> Why is that?

Sounds like a candidate for a foreign key relationship.

Ray.


-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie