Re: Regarding BITs vs. INTs

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Regarding BITs vs. INTs
Date: 2004-02-28 01:11:22
Message-ID: 20040227170913.C97148@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2004-02-28 01:20:36 Re: Regarding BITs vs. INTs
Previous Message Jim Wilson 2004-02-28 00:54:09 Re: Restoring a table with a different name