How to do full text search in postgresql on multiple tables?

Question

PostgreSQL

Hello. I have 2 tables:

CREATE TABLE documents
(
  id serial NOT NULL,
  name character varying(512),
  accept_date date,
  "number" character varying(255),
  document_type integer,
  docdate date
)

CREATE TABLE paragraphs
(
  id bigserial NOT NULL,
  iddoc integer,
  "position" integer,
  text text
)

I'm trying to master the search on this article .
How can I search by document title and paragraph text (and some other fields), if these fields are in different tables.
Can this be done at all?

Answer 1

Use UNION