Re: chr(3) and 3::text - Mailing list pgsql-novice

OK,

And what is 3::text ?

 

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