Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get the precision and scale part of a decimal

Status
Not open for further replies.
gregitg

gregitg

Technical User
Oct 7, 2001
3
AT
Hi to everybody,

has somebody an idea how get the precision and scale part of a decimal/numeric datatype?

What I found out is: Both are encoded in the column atttypmod in the table pg_attribute. The column contains a value e.g. 983046 what stands for a decimal(15,2) (this I know accidantly).

Knows sombody the algorithm how to extract the precision and scale from such a value?

Many thanks in advance

Hans
 
Status
Not open for further replies.

Similar threads

OJSan
  • Locked
  • Question
On Postgresql 10 i can replace or rename the default Postgresql account?
Replies
0
Views
207
OJSan
OJSan
harfri
  • Locked
  • Question
Who can help me with a report in SQL
Replies
1
Views
209
feherke
feherke
dbuxton101
  • Locked
  • Question
Simple way of Exporting and Importing a Table
Replies
0
Views
189
dbuxton101
dbuxton101
wbower34
  • Locked
  • Question
sum hours fields into another table
Replies
0
Views
186
wbower34
wbower34
rs120p
  • Locked
  • Question
Which way to move pg_xlog why sym link and not Linux Mount point?
Replies
0
Views
193
rs120p
rs120p

Part and Inventory Search

Sponsor

Back
Top