Thread: Question about Numeric Types

Question about Numeric Types

From

Dave Lazar

Date:

03 February 2005, 21:39:28

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?

Any tips most appreciated.

Dave

Re: Question about Numeric Types

From

Andreas Pflug

Date:

28 March 2005, 18:21:16

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

Re: Question about Numeric Types

From

"Sune B. Woeller"

Date:

07 September 2005, 21:22:18

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
>