RE: chr(3) and 3::text

From: gmail Vladimir Koković <vladimir.kokovic@gmail.com>
Sent: Saturday, March 28, 2020 6:39 AM
To: Ken Benson <Ken@infowerks.com>; pgsql-novice@postgresql.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

 

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