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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
