CREATE TABLE public.mynotes
(
  id integer NOT NULL,
  afullname character varying(255),
  ashortname character varying(255),
  atext text,
  cfullname character varying(255),
  cshortname character varying(255),
  ipath character varying(255),
  CONSTRAINT mynotes_pkey PRIMARY KEY (id)
)

CREATE INDEX atext_idx ON public.mynotes USING gin(to_tsvector('russian', atext));

SELECT cshortname
FROM public.mynotes
WHERE to_tsvector('russian', atext) @@ to_tsquery('russian', 'заяц');

SELECT cshortname
FROM public.mynotes
WHERE to_tsvector('russian', atext) @@ to_tsquery('russian', 'вышел заяц');