Subject: Re: chr(3) and 3::text
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-novice <pgsql-novice@postgresql.org>, Ken Benson <Ken@infowerks.com>
References: <769c6f0f-62e1-bd7d-b3bc-221619ab4680@gmail.com>
 <CAKFQuwaMQCb4QNA1+q8-3ZBgTMdoWFnvvSfUP4z6L5E7uCQOQw@mail.gmail.com>
From: =?UTF-8?Q?gmail_Vladimir_Kokovi=c4=87?= <vladimir.kokovic@gmail.com>
Message-ID: <d9d33c64-2288-736a-78a8-15921255501b@gmail.com>
Date: Sat, 28 Mar 2020 16:09:47 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.6.0
MIME-Version: 1.0
In-Reply-To: 
 <CAKFQuwaMQCb4QNA1+q8-3ZBgTMdoWFnvvSfUP4z6L5E7uCQOQw@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------CD94DA6AD27C4315C64A7DD7"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------CD94DA6AD27C4315C64A7DD7
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

David,

Sorry for copy/paste error:replace(Filler,3::text,'') WRONG !

Character 0x03 is valid in ASCII and UTF-8 character sets.

Main question is, why is 3::text == '3' ?

On 28.3.20. 16:04, David G. Johnston wrote:
> On Sat, Mar 28, 2020 at 6:21 AM gmail Vladimir Koković 
> <vladimir.kokovic@gmail.com <mailto:vladimir.kokovic@gmail.com>> wrote:
>
>
>     replace(Filler,chr(3),'') WORKS
>
>     replace(Filler3::text,'') WRONG
>
> "Wrong" is not a helpful term unless you describe what you are 
> expecting and how the result you got is different.  In particular just 
> reading what you've typed the "wrong" one fails because you forgot the 
> comma between "Fillter" and "3::text".  But I suspect you had a 
> different unsaid expectation here.
>
> In the future you should consider writing self-contained expressions, 
> ideally ones that don't use physical tables if the problem permits.
>
> David J.
>

--------------CD94DA6AD27C4315C64A7DD7
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>David,</p>
    <p>Sorry for copy/paste error:replace(Filler,3::text,'') WRONG !<br>
    </p>
    <p>Character 0x03 is valid in ASCII and UTF-8 character sets.</p>
    <p>Main question is, why is 3::text == '3' ?</p>
    <div class="moz-cite-prefix">On 28.3.20. 16:04, David G. Johnston
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAKFQuwaMQCb4QNA1+q8-3ZBgTMdoWFnvvSfUP4z6L5E7uCQOQw@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">
          <div class="gmail_default"
            style="font-family:arial,helvetica,sans-serif"><span
              style="font-family:Arial,Helvetica,sans-serif">On Sat, Mar
              28, 2020 at 6:21 AM gmail Vladimir Koković &lt;<a
                href="mailto:vladimir.kokovic@gmail.com"
                moz-do-not-send="true">vladimir.kokovic@gmail.com</a>&gt;
              wrote:</span><br>
          </div>
        </div>
        <div class="gmail_quote">
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
            0.8ex;border-left:1px solid
            rgb(204,204,204);padding-left:1ex">
            <div>
              <p><span class="gmail_default"
                  style="font-family:arial,helvetica,sans-serif"></span><br>
              </p>
              <p>replace(Filler,chr(3),'') WORKS</p>
              <p>replace(Filler3::text,'') WRONG</p>
            </div>
          </blockquote>
          <div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">"Wrong" is
              not a helpful term unless you describe what you are
              expecting and how the result you got is different.  In
              particular just reading what you've typed the "wrong" one
              fails because you forgot the comma between "Fillter" and
              "3::text".  But I suspect you had a different unsaid
              expectation here.</div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif"><br>
            </div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">In the
              future you should consider writing self-contained
              expressions, ideally ones that don't use physical tables
              if the problem permits.</div>
            <br>
          </div>
          <div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">David J.</div>
            <br>
          </div>
        </div>
      </div>
    </blockquote>
  </body>
</html>

--------------CD94DA6AD27C4315C64A7DD7--