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.94.2) (envelope-from ) id 1vAqmn-006ZQD-DY for pgsql-docs@arkaria.postgresql.org; Mon, 20 Oct 2025 14:22:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vAqmm-000r1O-CD for pgsql-docs@arkaria.postgresql.org; Mon, 20 Oct 2025 14:22:55 +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.94.2) (envelope-from ) id 1vAqmm-000r1G-3P for pgsql-docs@lists.postgresql.org; Mon, 20 Oct 2025 14:22:55 +0000 Received: from mail-wr1-x42b.google.com ([2a00:1450:4864:20::42b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vAqmj-002nmM-1h for pgsql-docs@lists.postgresql.org; Mon, 20 Oct 2025 14:22:54 +0000 Received: by mail-wr1-x42b.google.com with SMTP id ffacd0b85a97d-42557c5cedcso2416994f8f.0 for ; Mon, 20 Oct 2025 07:22:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1760970172; x=1761574972; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=+Hn6IyDZMqPkOaGBh3BO1DhT2znXYl+3ez93u0Adpwc=; b=MVnQr1HYElWordBjST628+kArX4hHk5ouNPu4DFqH50bnHwiY6zRUI+76v20KLLWSt jFHNbK/4LrrjvUU3Cm6nueuNaZe1LdIBc//9hvqZqCb1wj6eyhkKf83Il2O3loKhnd+2 pDqgSNHF8XG1Q3rdv12WYOBDJdn/va34qHb4Inmbpu/nXLg5iBeOFxplKxZzeSki6Mhq Vu+2cBbJW6yMZdDVDdC8NOcpV0aQlOKglWgeA1VSbBkGS942+B75XuurpIlWP3WW/T/u Bzv6CMY2rzyRT4rr5NfdzJsLZA60J/vpjbKipgfsYpkOr/vNNtUj8nJ7LZkdkIgMsSNF Sktg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760970172; x=1761574972; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=+Hn6IyDZMqPkOaGBh3BO1DhT2znXYl+3ez93u0Adpwc=; b=sAwE6nM276u3NPwVjPqbVFyMiridnQUKczKUViuaJdtCZiVkv9G7FaCEtdp7fOE/2t gIy8Y1tAnLgR/2k1WHKpWmn0tFhO27XXdhKnYjBRt7yIyUSDGivOjj8GaKXTjpFXDFz9 VLwZ5iwkZjN9N0BVrtI83BQcZVID8hYPwPuoKbcBtxpU+Fb6F8yVxkx/ydpx8+faVakR oVfVbvilol3X7GzsZiXRRMgMOKO8mkAEEmtOmBUcBoPnCK/U3ADLWVBnzUAA4hCcLEMd jl++JLbhG0JQaGEXVKeRm715USUg1JlYaBnh/cZJbyombNV7JNd8ijXNtcwBF4RfOzcK F3hQ== X-Forwarded-Encrypted: i=1; AJvYcCVVRPDu/Y/dc4ONiAiAxsc2hGkQZCk4S/jhvxhONPIf+b4PmbBwd6ppYBYxPsp3z6CjrYBOTk2MaiUK@lists.postgresql.org X-Gm-Message-State: AOJu0YzNcHmrmNQzpebnyXJJ2ZOf/hyqI39NhuB83yrXQNl4g+kk98AM aUjiqNPblZol+lj3/zp1anYUeGVaTBtm6uL4dZsXrK0mJ4zzD0uMongo5rcTGUifPeE= X-Gm-Gg: ASbGncvSGNsVhkOE2IIL8vAb7THpfsuTYXNtRujIhPHQGt7C4BcdDR+ZciepHtvXgbw yxfxONLt41cwBzBS3Iasp0JCVRTaiRU0l4UDnuj0QWq6klWPSlzG1IsGjjESFg7rVgm2hxVMbMS 8sP+PZld7fSfYH1c4D/Hypui1UpS4Irz6CuDDDUtNuTr2U+ZZ3CHnGFL/0chu+GHVFKKMRWROdQ v+Dv87OGGezIO6YC8YUIp+1L0QFC8ViFBebmjhokQeakkkG0cBAzE98ajZWtQ8aqCX/wOYnyedc mBCKY3RwMri0POuVsLBD8JK/L2oo93eNsMZ5G/1KsK7L1/SJpoKZTImK6L642rQ/Oks/nKxpOxz 5sgM1ygFeBbaSmLfPGYY5SHzarXc5I+XQxCwWS2G+6QhOka7o52X9CSBqlqR3LSE/I9qzACzaEn BA4FtWuc7zwHlC1jfUuosWq2DpA1egew== X-Google-Smtp-Source: AGHT+IGpS7Ioo0lv8pyfwQ0Bd861LqozwFfH98zHElUSXQ+dvoVveOFWSygK/c5vZXV0c04XhjHd1w== X-Received: by 2002:a05:6000:2284:b0:40f:5eb7:f24a with SMTP id ffacd0b85a97d-42704d14411mr9445365f8f.12.1760970171834; Mon, 20 Oct 2025 07:22:51 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:34bb:c58d:20f7:8937:c11e]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-427f00b9fa8sm15791873f8f.38.2025.10.20.07.22.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 20 Oct 2025 07:22:51 -0700 (PDT) Message-ID: <96ad1acfb43cc73b0cdbe74719f035b1ee3f77c0.camel@cybertec.at> Subject: Re: BPCHAR description in 8.3. Character Types is misleading and incomplete From: Laurenz Albe To: Sergei Katkovsky Cc: Tom Lane , Jeff Davis , pgsql-docs@lists.postgresql.org Date: Mon, 20 Oct 2025 16:22:50 +0200 In-Reply-To: References: <176044409338.770.16064383081308443747@wrigleys.postgresql.org> <1307875.1760556576@sss.pgh.pa.us> <92151c4debb48bbbaed4db81c79d73c36f619858.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-10-20 at 16:42 +0400, Sergei Katkovsky wrote: > On Sat, Oct 18, 2025 at 2:36=E2=80=AFAM Laurenz Albe wrote: >=20 > > But perhaps it is really better to leave things as they are now, perhap= s > > replacing "blank-trimming", perhaps as "variable-length string that ign= ores > > training blanks". >=20 > Looks like nobody is against "insignificant/ignorable trailing > whitespace" or anything like that anymore? Am I right? Any verbal description will never completely represent the facts. But I'd say that "ignores trailing blanks" (not tabs, for example) is a fairly accurate description. Yours, Laurenz Albe