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
Ответ на
Список
Дерево обсуждения
getting postgres to emulate mysql/sqlserver bit datatype "Anton Melser" <melser.anton@gmail.com>
Re: getting postgres to emulate mysql/sqlserver bit datatype Peter Eisentraut <peter_e@gmx.net>
Re: getting postgres to emulate mysql/sqlserver bit datatype "Joshua D. Drake" <jd@commandprompt.com>
Re: getting postgres to emulate mysql/sqlserver bit datatype Tom Lane <tgl@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 Jeff Davis <pgsql@j-davis.com>
Re: getting postgres to emulate mysql/sqlserver bit datatype Shane Ambler <pgsql@007Marketing.com>
Re: getting postgres to emulate mysql/sqlserver bit datatype Tom Lane <tgl@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>
Re: getting postgres to emulate mysql/sqlserver bit datatype Tom Lane <tgl@sss.pgh.pa.us>
Re: getting postgres to emulate mysql/sqlserver bit datatype "Anton Melser" <melser.anton@gmail.com>
"Anton Melser"  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
Дата:
От: Tom Lane
Дата:
FAQ