To: pgsql-novice@postgresql.org
From: =?UTF-8?Q?gmail_Vladimir_Kokovi=c4=87?= <vladimir.kokovic@gmail.com>
Subject: chr(3) and 3::text
Message-ID: <769c6f0f-62e1-bd7d-b3bc-221619ab4680@gmail.com>
Date: Sat, 28 Mar 2020 14:21:39 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.6.0
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------0D137CB1BC98B71545D08B51"
Content-Language: en-US
Precedence: bulk

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

Hi,

Why is chr(3) is different than 3::text ?

Examples:

replace(Filler,chr(3),'') WORKS

replace(Filler3::text,'') WRONG

Vladimir Kokovic, DP senior (69)
Serbia, Belgrade, March 28, 2020


--------------0D137CB1BC98B71545D08B51
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Hi,</p>
    <p>Why is chr(3) is different than 3::text ?</p>
    <p>Examples:</p>
    <p>replace(Filler,chr(3),'') WORKS</p>
    <p>replace(Filler3::text,'') WRONG<br>
    </p>
    <p><span class="tlid-translation translation" lang="en"><span
          title="" class="">Vladimir Kokovic, DP senior (69)<br>
          Serbia, Belgrade, March 28, 2020</span></span></p>
    <p><span class="tlid-translation translation" lang="en"><span
          title="" class=""><br>
        </span></span></p>
  </body>
</html>

--------------0D137CB1BC98B71545D08B51--