chr(3) and 3::text

From: gmail Vladimir Koković <vladimir(dot)kokovic(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: chr(3) and 3::text
Date: 2020-03-28 13:21:39
Message-ID: 769c6f0f-62e1-bd7d-b3bc-221619ab4680@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ken Benson 2020-03-28 13:35:28 RE: chr(3) and 3::text
Previous Message Denis Gantsev 2020-03-26 22:34:49 Re: psql: can't get readline support