Home > mailing lists

Regular Expression for 'and' instead of 'or' - Mailing list pgsql-sql

From	Samuel J. Sutjiono
Subject	Regular Expression for 'and' instead of 'or'
Date	February 22, 2002 15:14:07
Msg-id	023101c1bbc3$03a33910$110a010a@headquarters.wcgroup.com Whole thread Raw
Responses	Re: [GENERAL] Regular Expression for 'and' instead of 'or' (Fernando Schapachnik <fschapachnik@vianetworks.com.ar>) Re: Regular Expression for 'and' instead of 'or' (Peter Eisentraut <peter_e@gmx.net>)
List	pgsql-sql

This expression matches the word socks or shoes or nike in product category

where productdescr ~* '(socks|shoes|nike)'

Does anybody know what the expression should be if I want to do 'and' of those key words instead of 'or' ?

Thanks,

Sam

From: "Josh Berkus"
Date: 22 February 2002, 14:55:26
Subject: Re: Date Problem

From: "Nick Fankhauser"
Date: 22 February 2002, 15:21:51
Subject: Re: Page Management