Inconsistent cast to "char"

From: "Ian R(dot) Campbell" <ian(dot)campbell(at)thepathcentral(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Inconsistent cast to "char"
Date: 2021-12-02 16:24:42
Message-ID: CAOC8YUcXymCMpC5d=7JvcwyjXPTT00WeebOM3UqTBreOD1N9hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I noticed that the following does not produce consistent cast results:

select 1::int8::"char", 1::int4::"char", 1::int2::"char"

The following yields 49, 1, 49 respectively:

select 1::int8::"char"::int, 1::int4::"char"::int, 1::int2::"char"::int

regards,
Ian Campbell

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-12-02 18:05:10 BUG #17309: Memory consumption
Previous Message Darafei Komяpa Praliaskouski 2021-12-02 06:02:09 Re: BUG #17302: gist index prevents insertion of some data