joins with text search - Mailing list pgsql-general

From pg@slatech.com
Subject joins with text search
Date
Msg-id alpine.BSF.2.00.1009071707490.81227@gozaimasu.pair.com
Whole thread Raw
Responses Re: joins with text search  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
hi-

supposing i have the following table structure:

vendors
- id int
- name varchar

products
- product_list_id int
- vendor_id int references vendors
- part_number varchar
- description varchar
- price
- textsearch

how can i execute some type of join and get the name of the vendor to be
included in the textsearch column of the products table?

i am currently populating the textsearch column with the following
command:

UPDATE
products
SET
textsearch=setweight(to_tsvector('english', description), 'A') ||
setweight(to_tsvector('english', part_number, 'B')
WHERE
product_list_id=3


Is there a way I can join products.vendor_id with vendors.id and get the
vendor.name in the textsearch column as well?

Thanks,
Clark



pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: "private" installation of postgres
Next
From: "Brendan Hill"
Date:
Subject: Postgres 32bit on Windows 64bit, related components