getting postgres to emulate mysql/sqlserver bit datatype - Mailing list pgsql-general

From Anton Melser
Subject getting postgres to emulate mysql/sqlserver bit datatype
Date
Msg-id 92d3a4950702111342w59b3724cg5cb691957004681b@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Hi,
I am trying to port an app to postgres and have come up against a most
annoying problem. The app works with both mysql and sqlserver, who
both seem to have a bit datatype instead of a proper boolean like pg.
Alas, pg won't accept 1 and 0 for boolean... and npgsql won't convert
my numeric(1) into a boolean (and shouldn't either!). Is there any way
to force pg to accept 1 and 0 for boolean? I know it probably isn't
optimal, but hey. If there is a standard way to do this (and no,
rewriting is not an option) I'm all ears.
Cheers
Antoine

pgsql-general by date:

Previous
From: "Phil Endecott"
Date:
Subject: "no value found for parameter 1" error for query with no parameters
Next
From: Peter Eisentraut
Date:
Subject: Re: "no value found for parameter 1" error for query with no parameters