Re: Regarding BITs vs. INTs

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Regarding BITs vs. INTs
Дата
Msg-id 20040227170913.C97148@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Regarding BITs vs. INTs  (Bill Moran <wmoran@potentialtech.com>)
Ответы Re: Regarding BITs vs. INTs  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-general
On Fri, 27 Feb 2004, Bill Moran wrote:

> I hadn't really looked at this until I started having problems with it.
>
> For those who haven't been following along, I'm converting an application
> originally written in MSSQL to Postgres.
>
> I'm a little startled by how BIT fields are handled differently.  Apparently,
> MSSQL converts freely between BIT and INT.  Those who know, already know that
> Postgres doesn't do this.

No, but IIRC, it does allow casts between them, it just requires that you
explicitly mark that you want to cast the value.  If you really want to,
you could consider changing those casts into implicit casts and see if
that does what you want.

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

Предыдущее
От: "Jim Wilson"
Дата:
Сообщение: Re: Restoring a table with a different name
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Regarding BITs vs. INTs