| From: | gmail Vladimir Koković <vladimir(dot)kokovic(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org>, Ken Benson <Ken(at)infowerks(dot)com> |
| Subject: | Re: chr(3) and 3::text |
| Date: | 2020-03-28 15:09:47 |
| Message-ID: | d9d33c64-2288-736a-78a8-15921255501b@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
David,
Sorry for copy/paste error:replace(Filler,3::text,'') WRONG !
Character 0x03 is valid in ASCII and UTF-8 character sets.
Main question is, why is 3::text == '3' ?
On 28.3.20. 16:04, David G. Johnston wrote:
> On Sat, Mar 28, 2020 at 6:21 AM gmail Vladimir Koković
> <vladimir(dot)kokovic(at)gmail(dot)com <mailto: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 | David G. Johnston | 2020-03-28 15:25:52 | Re: chr(3) and 3::text |
| Previous Message | David G. Johnston | 2020-03-28 15:04:20 | Re: chr(3) and 3::text |