no "+" operator for smallint and bigint

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема no "+" operator for smallint and bigint
Дата
Msg-id 3E59FFB8.5060708@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: no "+" operator for smallint and bigint
Список pgsql-general
Postgres (7.3.2) doesn't seem to know how to add smallint's to bigint's ...

PG=# select 8::smallint + 8::bigint;
ERROR:  Unable to identify an operator '+' for types 'smallint' and 'bigint'
     You will have to retype this query using an explicit cast

This is surely just an oversight right?

I was trying to add two columns, a smallint col to a bigint col, and
store the result in the bigint col ... only to find to my surprise that
PostgreSQL didn't know how to add smallints to bigints ...

This will be fixed right? ;)

Jc


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

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: A few questions to real pgsql gurus
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: no "+" operator for smallint and bigint