BUG #17765: SELECT CAST(true AS BIGINT);

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: vvinnikov(at)list(dot)ru
Subject: BUG #17765: SELECT CAST(true AS BIGINT);
Date: 2023-01-31 13:39:58
Message-ID: 17765-3090f5817e7832f5@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17765
Logged by: Vladimir Vinnikov
Email address: vvinnikov(at)list(dot)ru
PostgreSQL version: 15.1
Operating system: x86_64-pc-linux-gnu
Description:

ERROR: cannot cast type boolean to bigint

That's inconsistent since casting boolean to int is OK (SELECT CAST(true AS
INT);) or double casting is OK (SELECT CAST(CAST(true AS INT) AS BIGINT);).

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2023-01-31 14:48:53 Re: BUG #17765: SELECT CAST(true AS BIGINT);
Previous Message Gunnar "Nick" Bluth 2023-01-31 12:27:59 Re: BUG #17760: SCRAM authentication fails with "modern" (rsassaPss signature) server certificate