RE: chr(3) and 3::text

From: gmail Vladimir Koković <vladimir(dot)kokovic(at)gmail(dot)com>
Sent: Saturday, March 28, 2020 6:39 AM
To: Ken Benson <Ken(at)infowerks(dot)com>; pgsql-novice(at)postgresql(dot)org
Subject: Re: chr(3) and 3::text

OK,

And what is 3::text ?

[Ken Benson] that means convert the numeric value “3” to a text data type … similar to CAST(NumericValue as text) in MSSQL

On 28.3.20. 14:35, Ken Benson wrote:

From: gmail Vladimir Koković <vladimir(dot)kokovic(at)gmail(dot)com><mailto:vladimir(dot)kokovic(at)gmail(dot)com>
Sent: Saturday, March 28, 2020 6:22 AM
To: pgsql-novice(at)postgresql(dot)org<mailto:pgsql-novice(at)postgresql(dot)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