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  (gmail Vladimir Koković <vladimir.kokovic@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Bzzzz
Дата:
Сообщение: Re: chr(3) and 3::text
Следующее
От: gmail Vladimir Koković
Дата:
Сообщение: Re: chr(3) and 3::text