BUG REPORT: Unable to cast boolean::smallint

Поиск
Список
Период
Сортировка
От James Pittman
Тема BUG REPORT: Unable to cast boolean::smallint
Дата
Msg-id 545A3454.80701@travelaudience.com
обсуждение исходный текст
Ответы Re: BUG REPORT: Unable to cast boolean::smallint
Список pgsql-bugs
It does not seem possible to be able to cast a boolean to a smallint.

Whilst the following is possible:

SELECT true::int;

 int4
------
    1
(1 row)


The following is not (as of 9.4beta3)

SELECT true::smallint;
ERROR:  cannot cast type boolean to smallint


It would seem logically consistent that both cases would hold true


Apologies if this is more of a 'feature request' than a bug.





Kind regards,


James

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: [pgsql-www] BUG #11872: row height is not quite tall eneough
Следующее
От: James Pittman
Дата:
Сообщение: BUG REPORT: GiST - default operator type for boolean