Re: Binary data type with other output method

[Andrew Dunstan <andrew(at)dunslane(dot)net>]

Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> 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.