Re: [SQL] extracting words

2008-04-23 Thread Tarlika Elisabeth Schmitz
On Wed, 23 Apr 2008 09:13:03 -0400 Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Tarlika Elisabeth Schmitz wrote: > > > I need to extract the words from department_name and product_name > > (words are separated by spaces) and get something like: > > > > 1 cakes > > 1 desserts > > 1 apple > > 1 cru

Re: [SQL] extracting words

2008-04-23 Thread Alvaro Herrera
Tarlika Elisabeth Schmitz wrote: > I need to extract the words from department_name and product_name > (words are separated by spaces) and get something like: > > 1 cakes > 1 desserts > 1 apple > 1 crumble > 2 cakes > 2 desserts > 2 cheese > 2 cake > 3 starters > 3 soups > 3 french > 3 onion > 3