| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | gmail Vladimir Koković <vladimir(dot)kokovic(at)gmail(dot)com> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: chr(3) and 3::text |
| Date: | 2020-03-28 15:04:20 |
| Message-ID: | CAKFQuwaMQCb4QNA1+q8-3ZBgTMdoWFnvvSfUP4z6L5E7uCQOQw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Sat, Mar 28, 2020 at 6:21 AM gmail Vladimir Koković <
vladimir(dot)kokovic(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | gmail Vladimir Koković | 2020-03-28 15:09:47 | Re: chr(3) and 3::text |
| Previous Message | Bzzzz | 2020-03-28 14:59:50 | Re: chr(3) and 3::text |