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@xxxxxxxxxxxx
