Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9WRv-001VUB-0T for pgsql-docs@arkaria.postgresql.org; Sun, 05 Apr 2026 23:00:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9WRt-005Kau-1Q for pgsql-docs@arkaria.postgresql.org; Sun, 05 Apr 2026 23:00:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9WRt-005Kam-0B for pgsql-docs@lists.postgresql.org; Sun, 05 Apr 2026 23:00:09 +0000 Received: from mail-yx1-xb12c.google.com ([2607:f8b0:4864:20::b12c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w9WRr-00000000l2R-0mnJ for pgsql-docs@lists.postgresql.org; Sun, 05 Apr 2026 23:00:08 +0000 Received: by mail-yx1-xb12c.google.com with SMTP id 956f58d0204a3-64d5a7926cfso3104719d50.2 for ; Sun, 05 Apr 2026 16:00:07 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775430006; cv=none; d=google.com; s=arc-20240605; b=OgiSSbrSFqb1JtfUYyr/4RcRYV83ji2DiyLh0PIXuxHJ5weUdkyMYs6qCaExqmBn2e pit2V/5rK4i0sIgMnqkHO+Je5zdmfh2f3Ed/16OTIbMPIVkzAk4E0oCcsRshg8RwYdUH NKIQ+YnVRCP/39Lb0fdXWv0DoaOLpkRgbP3v0U+IdcnJOQHFLvbHJLEX7uFiz29sfOOt Dm2CruJThL8WmAOSvehDswTxhQboqR5isC5vU5YZo2JRIqVfaUWWu7XFdZ8pvCoumwAe xC2KlV/81y1ae2YkAdWKzWxETB3WLGnh+CvXxjpWT9jAVdEJLrZu4eK7PFin3zdSbdaw WR7w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=/+B6qXDZQEXju8xzHk5FFuHrghTUOGSzJVZ+eQFIj1c=; fh=RJK4OOoxcRlCK7RDwAfhLOhll4wySH4lPPXsRPevCs4=; b=OCmF0znoVAM6FgnMjjkM8w3tSvO+g90M9W7XXyVpcgKiOPbjwSSZvLXvi/OKO6nVAR 6o7Qco3wqmdO4hOw/FioHP41v6j8QorzBSkx6AZpMYlii0zCVmyLaucwfj1E9lNVe8iM yEKK5+8K4Ba6j0YUmd4iAjtXq0o6VvsJoE0bKT6hiyNbO3PzZuKdZ9wkL7w4gr2fuEh6 /78JX5tnzPP/n2rCyzKyF5Cxjhpv8/EmJHwGiyFoZPEDa5EBt202I3vWZqa5biMKJf90 P2jHhQCf/SaiB+MXuRiI6ZX+REsaM2uAz4e2twLDZaCO6rUGFZSkEaMMLPfeoEUYQC1t gzkQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775430006; x=1776034806; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=/+B6qXDZQEXju8xzHk5FFuHrghTUOGSzJVZ+eQFIj1c=; b=tI1DPCfhWQNHyxaRHb1xlnkwbXl3NebLJsRYOiS0CeP23Zy+fUCyzJKtQp2VQW/vkD Ye1PkOxhzgEaUa2fapKKpV19uMIHMh3vLzXuqXeNrxnNMHpysK7wsj6mz2scfv3E2XmR +tqBc26C5bBi7yrX6HCcIu0HRQyGLd2bHDAj+qRPRfJb0yxaCjrbox2u2vrapZpU4TJm +4JchNtbkKXE8ZpGdRXUE1hmG3bnb2nKz/WqLejXsip22dl+ZfW6f3mgHe7OB1uXCTyo I8J1dLjZWK6dcSL8mpRhfEgcBk1ecoQ2u0GfCGO+gM4zEFUyC5USwAtH4s33Bhm4C6E0 LhAQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775430006; x=1776034806; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=/+B6qXDZQEXju8xzHk5FFuHrghTUOGSzJVZ+eQFIj1c=; b=Cvt0/kD6JY8C/8K/F/jihDKhWQM4+xhvEjgXT5Q7ehJUdes3eIk543bee8zirOR8yQ kJwqF534WdRHjmo2QchjhzVN8R1VBYHPsJkCMBZthMZzz//mv+LksTDHOkFLtHiQm2Wz oNM1C2bDIU2nI43Dd6Wnlr9F4Y9IvOh8uqc+0YK8L0m/Df8tXEOCeC+YsO7DyskIrs7i cQKPz6DkiU1584FT1m5+qFVnXQMGaj0iJiX/fDTSsXXdcoT0jsWGkQXhusMsqWPonoWf a7O9/skcsT/dzPDvF254tOqUgBgjtbSGJWGhzlPQnaSEHhUZYmHM010Txb1xXdxaFX5k 9A3g== X-Gm-Message-State: AOJu0YzayxIDjjslFiH+Esg+ss4G2phW5LjNQRbbDYVPMiX1BuDA3jXN OHMi0rEVP1MmxkuDYSGKXnTMF5ISNwmQWQfQLB9bByRCwKOo4yZcUhHWachNdC8qDW2Bdyls5Ux 2Rs2q5V2BE7FBaEeo/5PfJQHOthKmVMsApyMq X-Gm-Gg: AeBDieu1/8ut41sypXOuLgPOLoyhhxSO1VFWj2jlSF36KXnTjvRoJnenkwsg/GjQQBg ayBhfOH9O6wHGFnSnTdINLSqc9L6VAkAJqOIr8JeWre8X73lWcZjKmHUluKWPcKbNf9fv6eO1tZ x0urIylrP7YBd9I2EJXMmFW/zR9fs+tfI9Qv1aTQK1TooPTeDnW2FnxA8TqNdyb6U9BUQgCs7QC wfJOgiW2waR1DLx30vYpsHFHBpqB3sfEzy8uSpOkAzRXFgFuFYUgmoU6kSBoXo89gFOMvT4GPfv wX2ZGQ== X-Received: by 2002:a05:690e:1512:b0:64a:d04e:a340 with SMTP id 956f58d0204a3-6504868fd34mr9906706d50.11.1775430006492; Sun, 05 Apr 2026 16:00:06 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:7010:53cf:b0:50b:f104:b8b7 with HTTP; Sun, 5 Apr 2026 16:00:03 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Sun, 5 Apr 2026 16:00:03 -0700 X-Gm-Features: AQROBzASETQ9pY0yM2WWeEdkLSUSkn0nRfP1g9ufigvZUsGx1Z1YNmCPb-FXueQ Message-ID: Subject: Re: issue in the doc To: Yousef Mohamed Cc: "pgsql-docs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000dc51d0064ebe8292" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000dc51d0064ebe8292 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sunday, April 5, 2026, Yousef Mohamed wrote: > > Question: > > In the expression: > to_tsvector(x) @@ plainto_tsquery(y) > > what do x and y refer to exactly? > Local variables for the single expression being described. x is a text typed value capable of being parsed as a vector, y is a text typed value capable of being parsed as a query. (Or unknown, which then defaults to text.). > > are they correspond to the left-hand and right-hand sides of the original > expression (text @@ text) ? > In that x comes before y in the English alphabet just like in that left-to-right language left comes physically before right, yes. (text @@ text) isn=E2=80=99t an expression, it=E2=80=99s one=E2=80=99s way = of writing the name of a type. if yes , i think it's better to mention the order of the x and y like : > (x @@ y ) or ( y @@ x) > I=E2=80=99m not following how you think this could be improved. I get it= =E2=80=99s very western-centric, and admit it took me a moment to understand, but once I did it seems quite clear to me. A concrete change to consider would be helpful if this still doesn=E2=80=99t make sense. I have a few thoughts of= my own, chief among them being using real examples, but it doesn=E2=80=99t really m= y threshold to work on at this time. David J. --000000000000dc51d0064ebe8292 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sunday, April 5, 2026, Yousef Mohamed <yousssef.mohammmed.12@gmail.com> wrote:

Question:

In the express= ion:
to_tsvector(x) @@ plainto_tsquery(y)

what do x and y refer t= o exactly?

Local variables for the single expres= sion being described. =C2=A0x is a text typed value capable of being parsed= as a vector, y is a text typed value capable of being parsed as a query. = =C2=A0(Or unknown, which then defaults to text.).
=C2=A0


are they correspond to= the left-hand and right-hand sides of the original expression (text @@ tex= t) ?=C2=A0

In that x comes before y in the = English alphabet just like in that left-to-right language left comes physic= ally before right, yes.

(text @@ text) isn= =E2=80=99t an expression, it=E2=80=99s one=E2=80=99s way of writing the nam= e of a type.

if yes , i think it's better to mention the order of the x an= d y like : (x=C2=A0@@ y ) or ( y @@ x)=C2=A0

I= =E2=80=99m not following how you think this could be improved.=C2=A0 I get = it=E2=80=99s very western-centric, and admit it took me a moment to underst= and, but once I did it seems quite clear to me.=C2=A0 A concrete change to = consider would be helpful if this still doesn=E2=80=99t make sense.=C2=A0 I= have a few thoughts of my own, chief among them being using real examples,= but it doesn=E2=80=99t really my threshold to work on at this time.
<= div>
David J.

=C2=A0
--000000000000dc51d0064ebe8292--