Best way to simulate Booleans

From: "Peter Headland" <pheadland(at)actuate(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Best way to simulate Booleans
Date: 2009-07-07 01:22:50
Message-ID: 71F491F5DA99604A80DE49424BF3D02B0C089039@exchange8.actuate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I know, I know, PostgreSQL has Booleans that work very nicely.
Unfortunately, I have to create a schema that will work on Oracle as
well as PostgreSQL, by which I mean that a single set of Java/JDBC code
has to work with both databases. I have an XML meta-schema that enables
me to generate appropriate DDL; that handles all the INTEGER vs.
NUMBER(m,n) stuff. But Oracle simply has no Booleans, so I will have to
resort to some more or less ugly alternative. I am hoping that others
here have had to deal with this and can suggest an approach that will be
minimally loathsome.

<VENT>God I hate Oracle...</VENT>

--
Peter Headland
Architect - e.Reports
Actuate Corporation

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Joseph Krogh 2009-07-07 01:44:35 Order of "WITH RECURSIVE" output
Previous Message Andre Rothe 2009-07-04 20:50:53 Re: Sequences