Fernando Schapachnik <fschapachnik@vianetworks.com.ar> writes:
> You have to use something like:
> '(socks.*shoes.*nike)|(socks.*nike.*shoes)|...'
> where ... is every other possible combination. Not pretty, but that's
> a limitation of finite automata (or regular expressions, which are
> the same).
Seems a lot easier to do
WHERE field ~* 'socks' AND field ~* 'shoes' AND field ~* 'nike'
regards, tom lane