Skip site navigation (1) Skip section navigation (2)

extracting words

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 (view raw or flat)
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? 

Responses

pgsql-sql by date

Next:From: A. KretschmerDate: 2008-04-23 05:18:44
Subject: Re: extracting words
Previous:From: D'Arcy J.M. CainDate: 2008-04-22 16:01:42
Subject: Re: Problem with FOREIGN KEY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group