Re: Question about Numeric Types

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
>