From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG REPORT: Unable to cast boolean::smallint |
Date: | 2014-11-05 16:31:02 |
Message-ID: | 1415205062021-5825784.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Tom Lane-2 wrote
> James Pittman <
> j.pittman@
> > writes:
>> It does not seem possible to be able to cast a boolean to a smallint.
>
> Well, there are also not direct casts provided from boolean to bigint,
> numeric, real, or double precision ;-). I'm not terribly excited about
> this.
So why is there one for Boolean to int?
To the OP, why do you think you want one?
While I haven't used it much converting Boolean to zero/one for use in a
math formula is a known use case though likely one where the difference
between int and smallint would probably be marginalized.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-REPORT-Unable-to-cast-boolean-smallint-tp5825768p5825784.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2014-11-05 16:35:14 | Re: BUG #11882: make HAVE_WORKING_LINK an option |
Previous Message | Tom Lane | 2014-11-05 15:13:42 | Re: BUG REPORT: Unable to cast boolean::smallint |