Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
I think all you need to do it this:
Take the code for boolout() in src/backend/utils/adt/bool.c, adjust it
and and make it a new function boolout2. Use pgxs to make it a loadable
module.
Then load it and adjust the catalog entry for the bool type to use
boolout2 instead of boolout.
Then start fixing pg_dump, psql, and every other bit of client-side code
that expects the boolean columns in the system catalogs to read out as
't'/'f' ...
hmm, good point. Oh, well.
I think you'd really need a separate type. But have you considered
something simple like
CREATE DOMAIN boolint AS int CHECK (value = 0 OR value = 1)
Of course, that's not exactly what he asked for. Maybe we need to know
more about the case.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
