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 1maL2T-00009c-GV for pgsql-sql@arkaria.postgresql.org; Tue, 12 Oct 2021 16:54:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maL2S-0006Xy-2p for pgsql-sql@arkaria.postgresql.org; Tue, 12 Oct 2021 16:54:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maL2R-0006Xo-Pd for pgsql-sql@lists.postgresql.org; Tue, 12 Oct 2021 16:54:03 +0000 Received: from mail-il1-x129.google.com ([2607:f8b0:4864:20::129]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1maL2P-00078V-Qu for pgsql-sql@lists.postgresql.org; Tue, 12 Oct 2021 16:54:02 +0000 Received: by mail-il1-x129.google.com with SMTP id y17so22348262ilb.9 for ; Tue, 12 Oct 2021 09:54:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=33L3nbifAoQa8CriHPpmewetjEDkuzgfyijftu1SRsQ=; b=loFSzfS8y4FCdPXmrOOOMuuo6HYm1xChUlAJETffBtqQAjn0k0ixBcPN6irdAWMjhm EGCJK93sBK7qiSMAXJ4zHil0cT6fZ1j9x/MYR2Xp+Fvy9xI+D+WspQu2Rz823FHE7UnX jqktBp2Qk9bnToddMwHMh1cY82IBP1OAqzyvSnfSW/pS+HIoI0MpZr3/jnMjvUYhVpTp 204fxXLYSFQVnxl9vQydaf+9LL2AuFLET/wEEsYAQv0w4fYKTq3n7YN2WW55SYb9sTXk r8YuDrvFhQDFHjHCP0VzDKVbll+owG/nDSn1qcsN3Rvloqm0sl1PSPeHFDyJHdy65WfV uLSQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=33L3nbifAoQa8CriHPpmewetjEDkuzgfyijftu1SRsQ=; b=bdWPtTj6OjQ0NiTZguyI/SrlTt1hC5GM6z+CdWsQAVBvZWaamDyAfvW4ET2ZmB8JkM 3dnDZfsdcugp/3yB6Q6c3/EWzpOdrs9u1DgNF/YPUHyb/1LhLP+xK/S5wUQeQ27FTIxv WUM+eb6F/8unYHPpe7Xh5egxzKDx7rj1PS389/17v5vn6htSv2z+XAQxWhZNsrx1pY1B BrLGYt4Tvb/fmZWNSl8MDr9Q0OrWUknuLn8C17IV5ZmOxlCnl5rZbHTCAWCLmnCauJPF 3mQlIgxLszHwFY9Hlwx9DlsKwkeJoyhS1lvUqcWI3D4vvrrAaNaMVZj0TZMN/aHxIZE+ XbBg== X-Gm-Message-State: AOAM530flJL0XyojeL6JVo36JJp/Kqs2jMUy+PHhDyeGDTmSdFwaaYIM cXxVkhBcweuq0PIpHxJwAl0= X-Google-Smtp-Source: ABdhPJxv7Z8WU1XqC+CagDKh07/8R9GwDWiKj2HT/JNBqDt51OeGiDcmv0nRgSZnBt3YzXDSj/J7fw== X-Received: by 2002:a05:6e02:184f:: with SMTP id b15mr25522518ilv.187.1634057641158; Tue, 12 Oct 2021 09:54:01 -0700 (PDT) Received: from smtpclient.apple ([2601:681:5500:dde0:3940:6767:5f8b:93ed]) by smtp.gmail.com with ESMTPSA id d16sm6086187iof.50.2021.10.12.09.54.00 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 12 Oct 2021 09:54:00 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.120.0.1.13\)) Subject: Re: Fault with initcap From: Rob Sargent In-Reply-To: Date: Tue, 12 Oct 2021 10:53:59 -0600 Cc: pgsql-sql Content-Transfer-Encoding: 7bit Message-Id: References: To: Shaozhong SHI X-Mailer: Apple Mail (2.3654.120.0.1.13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Oct 12, 2021, at 10:30 AM, Shaozhong SHI wrote: > > I tried initcap and found a major problem with it. > > Initcap of notemachine is NoteMachine. My version 12 system gives Notemachine > > Initcap of Sainsbury's Bank is Sainsbury'S bank. > > This is not expected. > > Anyway to get around this problem? > > Regards, > > David