View Single Post

   
  #1 (permalink)  
Old 04-17-2008, 07:57 PM
Dave Lazar
 
Posts: n/a
Default Question about Numeric Types

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote