Re: Question about Numeric Types

["Sune B. Woeller" <sune(at)syntetisk(dot)dk>]

Andreas Pflug wrote:
> Dave Lazar wrote:
>
> > Hi,
> >
> > When using pgAdmin 1.2.0 to setup a new type, the option for a numeric
> > type offers a choice of length and precision. Postgresql defines
> > numeric as having scale and precision. Assuming length is synonymous
> > with scale, the precision is a locked field.
> >
> > If I want to specify a type numeric using pgAdmin with a scale of 6
> > and a precision of 12, how can I do this?
>
>
> Enter a length and see what happens...

I would consider this a bug in the user interface -
'length' in pgAdmin corresponds to 'precision'
and 'precision' in pgAdmin corresponds to 'scale'.

regards,
Sune B. Woeller


> Regards,
> Andreas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster