> > > format_type(name[, int4]) that formats an internal type and any size
> > > modifier for client consumption, like
> > > format_type('varchar', 8) => "CHARACTER VARYING(8)"
> > > format_type('my type') => "\"my type\""
> > > format_type('numeric', {xxx}) => "NUMERIC(9,2)"
>
> Ooh, that *is* a good idea (though the exact name of the function may
> evolve)! Sorry I missed seeing it in Peter's earlier postings.
>
> Funny how we can go for years banging our heads on an issue and have
> something like this (ie a good idea on the subject) pop up out of the
> blue.
>
> Presumably we would include a function taking the conversion the other
> direction too...
Not sure it is really needed. We already to the translation in gram.y.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
