Re: Question about Numeric Types

[Andreas Pflug <pgadmin(at)pse-consulting(dot)de>]

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...

Regards,
Andreas