I tried to search for all posts including the word “About”.
It returned 0 results, despite having a post titled “About …” in every category.
Is the word “About” excluded for some reason?
1 Like
Yes it is excluded, read all about postgresql - List of StopWords in Postgres 9.1 - Super User
Current default English stopword list is:
dev:/usr/share/postgresql/10/tsearch_data# cat english.stop
i
me
my
myself
we
our
ours
ourselves
you
your
yours
yourself
yourselves
he
him
his
himself
she
her
hers
herself
it
its
itself
they
them
their
theirs
themselves
what
which
who
whom
this
that
these
those
am
is
are
was
were
be
been
being
have
has
had
having
do
does
did
doing
a
an
the
and
but
if
or
because
as
until
while
of
at
by
for
with
about
against
between
into
through
during
before
after
above
below
to
from
up
down
in
out
on
off
over
under
again
further
then
once
here
there
when
where
why
how
all
any
both
each
few
more
most
other
some
such
no
nor
not
only
own
same
so
than
too
very
s
t
can
will
just
don
should
now
10 Likes
Thank you @sam, I wasn’t aware of this.
1 Like