Postgres Pro
Downloads
Home   >   mailing lists

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

From Guillaume Lelarge
Subject Re: Robust ways for checking allowed values in a column
Date
Msg-id CAECtzeUk=t2VvDcL=dejPxFsoVKXRtTUzp0w9sTMeVjquL6LXw@mail.gmail.com
Whole thread Raw
In response to Robust ways for checking allowed values in a column  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-general
Tree view
Le mar. 25 janv. 2022 à 14:56, Shaozhong SHI <shishaozhong@gmail.com> a écrit :
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?


It works for me:

# select 'Backyard' ~ '^Canal$|^Drain$|^Foreshore$|^inlandRiver$|^Lake$|^lockOrFlightOfLocks$|^Marsh$|^Researvoir$|^Sea$|^tidalRiver$|^Transfer$';
┌──────────┐
│ ?column? │
├──────────┤
│ f        │
└──────────┘
(1 row)

So you will probably need a complete and reproducible example so that we could test it.


--
Guillaume.

pgsql-general by date:

Previous
From: Shaozhong SHI
Date:
Subject: Robust ways for checking allowed values in a column
Next
From: "David G. Johnston"
Date:
Subject: Re: Robust ways for checking allowed values in a column