Re: getting postgres to emulate mysql/sqlserver bit datatype

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: "Phil Endecott" <spam_from_postgresql_general(at)chezphil(dot)org>
Subject: Re: getting postgres to emulate mysql/sqlserver bit datatype
Date: 2007-02-11 23:29:33
Message-ID: 200702120029.34093.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Phil Endecott wrote:
> > Is there any way to force pg to accept 1 and 0 for boolean?
>
> There is something called "create cast ... without function" which
> /might/ do what you want.

No, it won't, mainly because int and boolean are not binary compatible.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Phil Endecott 2007-02-12 00:01:07 Re: "no value found for parameter 1" error for query with no parameters
Previous Message Phil Endecott 2007-02-11 23:09:43 Re: getting postgres to emulate mysql/sqlserver bit datatype