OK,
And what is 3::text ?
On 28.3.20. 14:35, Ken Benson wrote:
>
> *From:* gmail Vladimir Koković <vladimir(dot)kokovic(at)gmail(dot)com>
> *Sent:* Saturday, March 28, 2020 6:22 AM
> *To:* 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
>