Re: chr(3) and 3::text
| От | David G. Johnston |
|---|---|
| Тема | Re: chr(3) and 3::text |
| Дата | |
| Msg-id | CAKFQuwaMQCb4QNA1+q8-3ZBgTMdoWFnvvSfUP4z6L5E7uCQOQw@mail.gmail.com обсуждение исходный текст |
| Ответ на | chr(3) and 3::text (gmail Vladimir Koković <vladimir.kokovic@gmail.com>) |
| Ответы |
Re: chr(3) and 3::text
|
| Список | 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 по дате отправления: