Quick Links

Regular Expression for 'and' instead of 'or'

From:	"Samuel J(dot) Sutjiono" <ssutjiono(at)wc-group(dot)com>
To:	<pgsql-sql(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject:	Regular Expression for 'and' instead of 'or'
Date:	2002-02-22 17:04:38
Message-ID:	023101c1bbc3$03a33910$110a010a@headquarters.wcgroup.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general 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

Responses

Re: Regular Expression for 'and' instead of 'or' at 2002-02-22 18:15:14 from Fernando Schapachnik
Re: [SQL] Regular Expression for 'and' instead of 'or' at 2002-02-22 20:45:07 from Peter Eisentraut
Re: Regular Expression for 'and' instead of 'or' at 2002-02-22 21:26:44 from Medi Montaseri
Re: Regular Expression for 'and' instead of 'or' at 2002-02-23 06:25:26 from Rajesh Kumar Mallah

Browse pgsql-general by date

	From	Date	Subject
Next Message	Jean-Luc Lachance	2002-02-22 17:22:20	Re: environment variables, output format & setting current
Previous Message	Luis Amigo	2002-02-22 17:04:37	Re: How does Index Scan get used

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Nick Fankhauser	2002-02-22 17:13:49	Re: Page Management
Previous Message	Josh Berkus	2002-02-22 16:51:55	Re: Date Problem