From: | Tarlika Elisabeth Schmitz <postgresql(at)numerixtechnology(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | extracting words |
Date: | 2008-04-22 21:25:04 |
Message-ID: | 20080422222504.56bdb06d@dick.coachhouse |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I am not quite sure whether this would be sensible or indeed at
all possible to do in SQL:
TABLE product: product_pk, product_name, department_fk
TABLE product: department_pk, department_name
example data:
SELECT product_pk, department_name, product_name ... LEFT JOIN ...:
1, "cakes & desserts", "apple crumble"
2, "cakes & desserts", "cheese cake"
3, "starters & soups", "french onion soup"
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 soup
Would it be more sensible to produce a table join and split the result
into keywords programmatically?
--
Best Regards,
Tarlika Elisabeth Schmitz
A: Because it breaks the logical sequence of discussion
Q: Why is top posting bad?
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2008-04-23 05:18:44 | Re: extracting words |
Previous Message | D'Arcy J.M. Cain | 2008-04-22 16:01:42 | Re: Problem with FOREIGN KEY |