SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 06:57 PM
| ||||
| ||||
 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      |
|
04-17-2008, 07:00 PM
| |||
| |||
| Re: Question about Numeric Types 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster |
|
04-17-2008, 07:08 PM
| ||||
| ||||
| 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 > ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
 |
« Re: Error in PgAdmin III 1.3.0 Version released at Septembeer 4, 2005
|
Compile error "cannot find -lcrypto" on Mandrake 10.2 for pgadmin3-1.2.2 »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 12:29 AM.
