Solved

is there a built-in type in postgres for a columns which can receive values in percent : 0-100?

Posted on 2007-11-22
4
210 Views
Last Modified: 2012-06-27
is there a possibility to have a columns that receives only values between  0 and 100?
0
Comment
Question by:toshi_
  • 2
  • 2
4 Comments
 
LVL 25

Expert Comment

by:Tomas Helgi Johannsson
ID: 20333792
   Hi!


Percentage is usually stored in a database either as an Integer value or as Float/Double value.

Regards,
   Tomas Helgi
0
 

Author Comment

by:toshi_
ID: 20334205
ok, but i'd like to control that values are not higher than 100, and not negatives.
0
 
LVL 25

Accepted Solution

by:
Tomas Helgi Johannsson earned 500 total points
ID: 20334266
WHen you create your table you can issue a check
like the attached code snippet shows

Regards,
  Tomas Helgi
postgres=# CREATE TABLE mytable (
postgres(#    nr integer,
postgres(#    percentige numeric,  CHECK (percentige > 0 and percentige <= 100)
postgres(# );
CREATE TABLE

Open in new window

0
 

Author Comment

by:toshi_
ID: 20334345
wonderful,
as i'm using pgAdminIII, i can add ckeck as constraints with graphical interface.
i never took notice of it.

thanks a lot.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question