Re: [GENERAL] regexp operator for array element compares needed

2012-04-13 Thread Sergey Konoplev
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

[GENERAL] regexp operator for array element compares needed

2012-04-12 Thread Gauthier, Dave
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