| From: | "Sune B(dot) Woeller" <sune(at)syntetisk(dot)dk> |
|---|---|
| To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Question about Numeric Types |
| Date: | 2005-09-07 20:20:19 |
| Message-ID: | 431F4B83.5090004@syntetisk.dk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roy Eugene Vinner | 2005-09-08 23:18:58 | Compile error "cannot find -lcrypto" on Mandrake 10.2 for pgadmin3-1.2.2 |
| Previous Message | Diego Gil | 2005-09-06 20:10:50 | compilation error |