Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Numerical data types
Integer data types
Floating point data types
7. Fractions: double precision and real data types
Decimal data types
Summary

Instruction

Excellent! You are now ready to move on to more complicated number types.

Apart from integer numbers, there are also fractions. In our database, we can use the double precision and real data types to store them. Just like with integer types, each database has its own types for these "floating point" numbers. Their ranges and precisions are always given in the documentation.

Exercise

Peter wants to introduce weight into the user profiles so that people can quickly browse the site based on their size preferences.

For now, let's just create a simple table called body with an integer column called user_id and a double precision column called weight.