You could use atttypmod to have a type that has a default output format
that you specify at type creation time.
>
>
> How about having output options for types? I know this can be
> implemented with functions and views, but it would be nice to able to
> output values in different formats by default (such as datetime =>
> seconds since the epoch)
>
> On Thu, 19 February 1998, at 22:04:34, Bruce Momjian wrote:
>
> > > Which functionality is that?
> > >
> > > On Thu, 19 February 1998, at 16:48:26, Bruce Momjian wrote:
> > >
> > > > Just to let people know, pg_attribute.atttypmod is now passed as the
> > > > third parameter to all in and out functions, so it is ready to go for
> > > > people who need this functionality.
> > >
> >
> > Things like decimal types with defined precision. decimal(10,2).
> >
> > --
> > Bruce Momjian
> > maillist@candle.pha.pa.us
>
--
Bruce Momjian
maillist@candle.pha.pa.us