Postgres Pro
Downloads
Home   >   mailing lists

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

From Shaozhong SHI
Subject Robust ways for checking allowed values in a column
Date
Msg-id CA+i5JwZ75h=VQN_rc8P5g_1+_boGQ=gv3b_KW-WPc7KR-nUKEQ@mail.gmail.com
Whole thread Raw
Responses Re: Robust ways for checking allowed values in a column  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Robust ways for checking allowed values in a column  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Robust ways for checking allowed values in a column  (Ray O'Donnell <ray@rodonnell.ie>)
List pgsql-general
Tree view
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?

Regards,

David

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Undetected Deadlock
Next
From: Guillaume Lelarge
Date:
Subject: Re: Robust ways for checking allowed values in a column