Numerical data types
Integer data types
Floating point data types
Decimal data types
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.
