Re: extracting words

Поиск
Список
Период
Сортировка
От Tarlika Elisabeth Schmitz
Тема Re: extracting words
Дата
Msg-id 20080423155735.2755b5c7@dick.coachhouse
обсуждение исходный текст
Ответ на Re: extracting words  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-sql
On Wed, 23 Apr 2008 09:13:03 -0400
Alvaro Herrera <alvherre@commandprompt.com> 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 crumble
> > 2 cakes
> > 2 desserts
> > 2 cheese
> > 2 cake
> > 3 starters
> > 3 soups
> > 3 french
> > 3 onion
> > 3 soup
> 
> regexp_split_to_table is handy (8.3 only):
> 
> select pk, regexp_split_to_table(product_name, '[& ]+') from products
> union
> select pk, regexp_split_to_table(dept_name, '[& ]+') from departments;
> 
> Add joins as desired.


This is neat!
Unfortunately, on the machine that I need this, we are running 7.4.

--


Best Regards,

Tarlika Elisabeth Schmitz


A: Because it breaks the logical sequence of discussion
Q: Why is top posting bad? 


В списке pgsql-sql по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: extracting words
Следующее
От: "Nacef LABIDI"
Дата:
Сообщение: First day of month, last day of month