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 1tagpe-004BuM-Kp for pgsql-general@arkaria.postgresql.org; Wed, 22 Jan 2025 19:56:11 +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 1tagpd-004WRt-Bm for pgsql-general@arkaria.postgresql.org; Wed, 22 Jan 2025 19:56:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tagpc-004WRl-Uh for pgsql-general@lists.postgresql.org; Wed, 22 Jan 2025 19:56:09 +0000 Received: from mail-oi1-x22e.google.com ([2607:f8b0:4864:20::22e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tagpa-000xvR-0m for pgsql-general@postgresql.org; Wed, 22 Jan 2025 19:56:08 +0000 Received: by mail-oi1-x22e.google.com with SMTP id 5614622812f47-3eb98ad8caaso126971b6e.0 for ; Wed, 22 Jan 2025 11:56:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1737575765; x=1738180565; darn=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=1rQsPZjXaF1V0pv3Zonz58Gw1duWnjL6990YbYD1Az4=; b=QFHyGg+khJEDUacpPYHKHD9oczfaaXz5limazy4eDfJCHOPAESWUUB9eKtkzGfQjxI gT52GgiK4cwK39NmXKo302BoC6JlMWJWW206za9jaglultPYXEYM9Ywq5O/QwdbuvyZH p1hVaZhnpnF5VUGcGzy7C01vBHsi3EBotUd0sZRbGRZjQzxG8Zd0LRkMqzTum5EPs/oY yR2PihrCqdKAVN4VR2RfO9ruPh/5KVjU0V1z5lXkUylv81KbT81mOZ1CaKjBET74WQ2z oRPB/NQ50KE6duY4M+jV4akyoTFd/TRdh7lpX8FPu1qRYjpOPvdObVPGjAw5kXkTw1Pq F/Iw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737575765; x=1738180565; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=1rQsPZjXaF1V0pv3Zonz58Gw1duWnjL6990YbYD1Az4=; b=MAuyU9AMqj3XrxnbTus133G+X3s3G4V4Lgn/BF68dFPmm6zT/7XF5IK0x8uuJaq6zJ ueO1pqwmqQJrq/f91lA1Rug0iUCT8qKsO0Tv9Kmsqc5N/bfHgLZ7ai58QhW3B/yQOrXA NBnWobpd5Tt5jZYAiVFOlF2Gi0PBBNwsQWlBeyQ7ZJQIcL6hMPDhOllZfkzmFAJeKWbS urWqPqLxoWfuhazdLvrjxqmhTKqKG+SmkBwXvKGkxS/BEy6nlOxfp8T/9m/jBl4ZdIKF 4icTGo0MhnEufdz4pxD5EE660s+gvqFRFgyJaW/cWEQeLhkA27tbGUlxaGKL1sqdL/eK 1H/w== X-Gm-Message-State: AOJu0YzZaUx4c3Em9dDwn6LsFki39i+c/00imiX7LNIXjqdlA4u6om9f AtZhiL0LI51Rojm7/aDrfIbFlzjkQaWCNOUYv5zJZNUz7HlDlJc8dm6FD3aICe4wbPZh/K4jBcU 1iQt7ZGnfe23kxrbaHRb0pc9jQ5Y= X-Gm-Gg: ASbGncvtEd8IX4Z1quyNqsNHOPmnnx831KpZneuhkeOj39psHokkRRwrz7/1w6YngMl FMCV1ptz3csXKjK10lRg1N8gyXSqmJSEdCB6+O2+2uzxFV3DCHgY= X-Google-Smtp-Source: AGHT+IGb+0gB1joZyBytoijsWloZONy1i8zTwsD2P53NXIcpxy/Eprz5bEOskI8swRnR476aKHkPLE7MTYKwoSaCTZc= X-Received: by 2002:a05:6808:8402:b0:3ec:d34f:4c82 with SMTP id 5614622812f47-3f19fc6b3c1mr11021170b6e.16.1737575764750; Wed, 22 Jan 2025 11:56:04 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a8a:184e:0:b0:577:9519:f64a with HTTP; Wed, 22 Jan 2025 11:56:04 -0800 (PST) In-Reply-To: References: From: "David G. Johnston" Date: Wed, 22 Jan 2025 12:56:04 -0700 X-Gm-Features: AbW1kvY0GM-Y6za7x7v5HYarcWeAJaOwzXmxXWCrnesXTnM42LakpQxPkgFaUQE Message-ID: Subject: Re: Meaning of + symbol at end of column string To: Rich Shepard Cc: "pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="0000000000003a7938062c50e2c0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003a7938062c50e2c0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, January 22, 2025, Rich Shepard wrote: > I use scripts to enter new rows in tables yet on rare occasions when I > select all columns from a table I'll find a "+" at the end of a string > value in one column. My web search finds no explanation. > > What does that + symbol mean in this context? > The value has a line break break character sequence at that point (I forget if it has any awareness of CR and CRLF differences=E2=80=A6) David J. --0000000000003a7938062c50e2c0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, January 22, 2025, Rich Shepard <rshepard@appl-ecosys.com> wrote:
I use scripts to enter new rows in tables yet on rare occa= sions when I
select all columns from a table I'll find a "+" at the end of= a string
value in one column. My web search finds no explanation.

What does that + symbol mean in this context?

The value has a line break break character= sequence at that point (I forget if it has any awareness of CR and CRLF di= fferences=E2=80=A6)

David J.

--0000000000003a7938062c50e2c0--