On Thu, Apr 12, 2012 at 10:50 PM, Gauthier, Dave
wrote:
> ... from 'a.,b.,c*,d*,ee'
You can not do like this.
> Don't even know if this sort of thing is possible. I didn't see any
> operator like this in the docs. May have to split out each and compare in
> nested loops sith atomic regexp comp
Hi:
v8.3.4 on linux
In plpgsql, I have something like this...
if ((string_to_array(check_values_text,',') <@ string_to_array((select
permitted_values from bi_constraints where bicolumn = 'fivr'),',')) = 'f')
It's just testing all the values in the check_values_text csv are in
permitted_values