Re: getting postgres to emulate mysql/sqlserver bit datatype

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Anton Melser" <melser(dot)anton(at)gmail(dot)com>
Cc: "Shane Ambler" <pgsql(at)007marketing(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: getting postgres to emulate mysql/sqlserver bit datatype
Date: 2007-02-13 02:48:07
Message-ID: 19841.1171334887@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Anton Melser" <melser(dot)anton(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-02-13 02:52:28 Re: Still unclear about PQexecParams and "create view"
Previous Message Tom Lane 2007-02-13 02:01:15 Re: daylight savings patches needed?