Postgres Pro
Downloads
Home   >   mailing lists

BUG #17765: SELECT CAST(true AS BIGINT); - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17765: SELECT CAST(true AS BIGINT);
Date
Msg-id 17765-3090f5817e7832f5@postgresql.org
Whole thread Raw
Responses Re: BUG #17765: SELECT CAST(true AS BIGINT);
Re: BUG #17765: SELECT CAST(true AS BIGINT);
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      17765
Logged by:          Vladimir Vinnikov
Email address:      vvinnikov@list.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);).

pgsql-bugs by date:

Previous
From: "Gunnar \"Nick\" Bluth"
Date:
Subject: Re: BUG #17760: SCRAM authentication fails with "modern" (rsassaPss signature) server certificate
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #17765: SELECT CAST(true AS BIGINT);