Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jaSKO-0001D7-34 for pgsql-docs@arkaria.postgresql.org; Sun, 17 May 2020 23:04:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jaSKL-0006xr-1W for pgsql-docs@arkaria.postgresql.org; Sun, 17 May 2020 23:04:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jaSKK-0006xk-NG for pgsql-docs@lists.postgresql.org; Sun, 17 May 2020 23:04:12 +0000 Received: from mail-qk1-x735.google.com ([2607:f8b0:4864:20::735]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jaSKH-0004ea-67 for pgsql-docs@lists.postgresql.org; Sun, 17 May 2020 23:04:11 +0000 Received: by mail-qk1-x735.google.com with SMTP id y22so8433483qki.3 for ; Sun, 17 May 2020 16:04:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=janin-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=GZNpVB4KxvJfKs9rD2ONumvoTG78U2oAvj/NrxTj/wY=; b=y6Gw7WBHutKxMcTH4+QjMmESWDriUaLxgD2tQ83OUYgPQRZJnxvkPiVXDIzcj0z5cZ 4pttUOwV8nzQg+x0rWHmcJQtsEqHX4z2a64NOIQ5MmouFP8nM0jwzZFuBbiurAQ9ja3O ROwdRwd+dDQ1NRz/vOX3Bt32MiRZskfclOgKImO2MvICtaXT977zkoEkBHRmr0gOlca/ JTw19abb0A6LlFSyR2KSSv6tH7YA6UGcdOvjlrrNc5U/L9/nvWbqBDBh3r+VxQ8Weq/s XDYAzZ2UxcX6g9gpfycWW4B8HPZ4nY2bbT5TEGcnNxJTtpsv0NjoHULRwq0RyOwLh9M7 WzmA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=GZNpVB4KxvJfKs9rD2ONumvoTG78U2oAvj/NrxTj/wY=; b=MnYHzOEYewdm9zKj+aolsOaWRt5awdrn0Sq+hGJTU+QFqGsq0L6uhEb/CKSUbwR30Q bChUGUlYKO9jjIzTccgSGRYGCs3h8wylbniRlznrNuba84DuMHF/aYd0bRbGRpRWQXMW RhabacUi1sEMc1XEQWjn1uKNWtFP6o319bhiVp6oe30x1j5iEKb6K8e7GKxdMZ2P3hOb lE/JAjv44bzAaxwzWPEK9yQg8ZTj9XngsvqsIrEYS5jN2p1l3wt9H6rplfRsyf/XFdSi IXv4xj5Hs2qYxePgDylDKCB34goO4pXN+DFORb6xim/QzqFFd8Qxc8Y5CdT6ClomUqhz BbGw== X-Gm-Message-State: AOAM530yrnMEfpOsmv3MxddE2hUZVW4mR+eyhgy4FHw9wL+v57rJRMOo rvbvdzV2oOq8o5aDjSNc6bnpzLwYixA= X-Google-Smtp-Source: ABdhPJziW0FveppdZ/O793VAlWac7sREbCDUO7j9ENj2NMFmgr5zQKwqvvprO8159bpn/T2xJGJwmw== X-Received: by 2002:a37:a193:: with SMTP id k141mr13083300qke.147.1589756646796; Sun, 17 May 2020 16:04:06 -0700 (PDT) Received: from janin.com (antioch.tamentis.com. [8.9.37.251]) by smtp.googlemail.com with ESMTPSA id x1sm6749563qkl.66.2020.05.17.16.04.05 (version=TLS1_2 cipher=ECDHE-ECDSA-CHACHA20-POLY1305 bits=256/256); Sun, 17 May 2020 16:04:06 -0700 (PDT) Date: Sun, 17 May 2020 19:04:04 -0400 From: Bertrand Janin To: pgsql-docs@lists.postgresql.org Cc: Alvaro Herrera Subject: Re: non-string or non-string Message-ID: <20200517230404.GG44458@janin.com> References: <158974990906.7031.8787889795019651207@wrigleys.postgresql.org> <20200517223128.GA8607@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <20200517223128.GA8607@alvherre.pgsql> User-Agent: Mutt/1.11.4 (2019-03-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > No, it's not the example but the operator description, and what it says > is > "string || non-string or non-string || string" > > so it's trying to illustrate that there are two options: > > string || non-string > non-string || string I see, that makes a lot more sense. > but maybe it's not super-clear about that. This is much clearer in the > docs for Postgres 13, which has been heavily reformatted: > https://www.postgresql.org/docs/devel/functions-string.html Oh wow, that's quite the change. I'm going to use the updated docs moving forward, it confused me at first, after years of visually parsing the previous format, but it's clearer once you understand the structure. Thanks, Bertrand