Re: getting postgres to emulate mysql/sqlserver bit datatype

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: getting postgres to emulate mysql/sqlserver bit datatype
Дата
Msg-id 19841.1171334887@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: getting postgres to emulate mysql/sqlserver bit datatype  ("Anton Melser" <melser.anton@gmail.com>)
Ответы Re: getting postgres to emulate mysql/sqlserver bit datatype  ("Anton Melser" <melser.anton@gmail.com>)
Список pgsql-general
"Anton Melser" <melser.anton@gmail.com> writes:
> ERROR: operator is not unique: boolean = integer

> I get this whether castcontext is 'a' or 'i'.

If you make both cast directions the same priority then the system has
no basis for choosing bool = bool over int = int or vice versa.  Try
making one direction 'i' and the other not.  I'm not sure which one
ought to be 'i', really --- it depends a lot on the details of the
queries you are trying to make work.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: daylight savings patches needed?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Still unclear about PQexecParams and "create view"