Subject: Re: chr(3) and 3::text
To: Ken Benson <Ken@infowerks.com>,
 "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
References: <769c6f0f-62e1-bd7d-b3bc-221619ab4680@gmail.com>
 <MWHPR19MB105454E5D45CE2FA723C545FA3CD0@MWHPR19MB1054.namprd19.prod.outlook.com>
From: =?UTF-8?Q?gmail_Vladimir_Kokovi=c4=87?= <vladimir.kokovic@gmail.com>
Message-ID: <e0537ea4-c3ec-179e-3ff6-2a9eaa45fba3@gmail.com>
Date: Sat, 28 Mar 2020 14:38:48 +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: 
 <MWHPR19MB105454E5D45CE2FA723C545FA3CD0@MWHPR19MB1054.namprd19.prod.outlook.com>
Content-Type: multipart/alternative;
 boundary="------------CB58D5E2876F534B8E10B7D5"
Content-Language: en-US
Precedence: bulk

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

OK,


And what is 3::text ?


On 28.3.20. 14:35, Ken Benson wrote:
>
> *From:* gmail Vladimir Koković <vladimir.kokovic@gmail.com>
> *Sent:* Saturday, March 28, 2020 6:22 AM
> *To:* pgsql-novice@postgresql.org
> *Subject:* chr(3) and 3::text
>
> Hi,
>
> Why is chr(3) is different than 3::text ?
>
> */[Ken Benson] Chr(3) – means return the character that has the ASCII 
> code of “3” – which is a control character./*
>
> https://w3resource.com/PostgreSQL/chr-function.php*//*
>
> Examples:
>
> replace(Filler,chr(3),'') WORKS
>
> replace(Filler3::text,'') WRONG
>
> Vladimir Kokovic, DP senior (69)
> Serbia, Belgrade, March 28, 2020
>
>
>
> Ken Benson | ken @ infowerks-dot-com
>

--------------CB58D5E2876F534B8E10B7D5
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>OK,</p>
    <p><br>
    </p>
    <p>And what is 3::text ?</p>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 28.3.20. 14:35, Ken Benson wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:MWHPR19MB105454E5D45CE2FA723C545FA3CD0@MWHPR19MB1054.namprd19.prod.outlook.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
span.tlid-translation
	{mso-style-name:tlid-translation;}
span.EmailStyle20
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
        <div>
          <div style="border:none;border-top:solid #E1E1E1
            1.0pt;padding:3.0pt 0in 0in 0in">
            <p class="MsoNormal" style="margin-left:.5in"><b>From:</b>
              gmail Vladimir Koković <a class="moz-txt-link-rfc2396E" href="mailto:vladimir.kokovic@gmail.com">&lt;vladimir.kokovic@gmail.com&gt;</a>
              <br>
              <b>Sent:</b> Saturday, March 28, 2020 6:22 AM<br>
              <b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:pgsql-novice@postgresql.org">pgsql-novice@postgresql.org</a><br>
              <b>Subject:</b> chr(3) and 3::text<o:p></o:p></p>
          </div>
        </div>
        <p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
        <p style="margin-left:.5in">Hi,<o:p></o:p></p>
        <p style="margin-left:.5in">Why is chr(3) is different than
          3::text ?<o:p></o:p></p>
        <p style="margin-left:.5in"><o:p> </o:p></p>
        <p><b><i>[Ken Benson] Chr(3) – means return the character that
              has the ASCII code of “3” – which is a control character.<o:p></o:p></i></b></p>
        <p><a href="https://w3resource.com/PostgreSQL/chr-function.php"
            moz-do-not-send="true">https://w3resource.com/PostgreSQL/chr-function.php</a><b><i><o:p></o:p></i></b></p>
        <p style="margin-left:.5in">Examples:<o:p></o:p></p>
        <p style="margin-left:.5in">replace(Filler,chr(3),'') WORKS<o:p></o:p></p>
        <p style="margin-left:.5in">replace(Filler3::text,'') WRONG<o:p></o:p></p>
        <p style="margin-left:.5in"><span class="tlid-translation"><span
              lang="EN">Vladimir Kokovic, DP senior (69)</span></span><span
            lang="EN"><br>
            <span class="tlid-translation">Serbia, Belgrade, March 28,
              2020</span></span><o:p></o:p></p>
        <p class="MsoNormal"><span lang="EN"><br>
            <br>
          </span><o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal"><span style="font-family:&quot;Times New
            Roman&quot;,serif">Ken Benson | ken @ infowerks-dot-com<o:p></o:p></span></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p><o:p> </o:p></p>
      </div>
    </blockquote>
  </body>
</html>

--------------CB58D5E2876F534B8E10B7D5--