Re: Robust ways for checking allowed values in a column

[Ray O'Donnell]

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
r...@rodonnell.ie