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

From David G. Johnston
Subject Re: chr(3) and 3::text
Date
Msg-id CAKFQuwaMQCb4QNA1+q8-3ZBgTMdoWFnvvSfUP4z6L5E7uCQOQw@mail.gmail.com
Whole thread Raw
In response to chr(3) and 3::text  (gmail Vladimir Koković <vladimir.kokovic@gmail.com>)
Responses Re: chr(3) and 3::text  (gmail Vladimir Koković <vladimir.kokovic@gmail.com>)
List pgsql-novice
On Sat, Mar 28, 2020 at 6:21 AM gmail Vladimir Koković <vladimir.kokovic@gmail.com> wrote:


replace(Filler,chr(3),'') WORKS

replace(Filler3::text,'') WRONG

"Wrong" is not a helpful term unless you describe what you are expecting and how the result you got is different.  In particular just reading what you've typed the "wrong" one fails because you forgot the comma between "Fillter" and "3::text".  But I suspect you had a different unsaid expectation here.

In the future you should consider writing self-contained expressions, ideally ones that don't use physical tables if the problem permits.

David J.

pgsql-novice by date:

Previous
From: Bzzzz
Date:
Subject: Re: chr(3) and 3::text
Next
From: gmail Vladimir Koković
Date:
Subject: Re: chr(3) and 3::text