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
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:
Would it be more sensible to produce a table join and split the result
into keywords programmatically?
Tarlika Elisabeth Schmitz
A: Because it breaks the logical sequence of discussion
Q: Why is top posting bad?
pgsql-sql by date
|Next:||From: A. Kretschmer||Date: 2008-04-23 05:18:44|
|Subject: Re: extracting words|
|Previous:||From: D'Arcy J.M. Cain||Date: 2008-04-22 16:01:42|
|Subject: Re: Problem with FOREIGN KEY|