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
206 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 24

Expert Comment

by:Tomas Helgi Johannsson
Comment Utility
   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_
Comment Utility
ok, but i'd like to control that values are not higher than 100, and not negatives.
0
 
LVL 24

Accepted Solution

by:
Tomas Helgi Johannsson earned 500 total points
Comment Utility
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_
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Today I came across an interesting issue that had me pulling my hair out.  I was troubleshooting a new internal web site which uses integrated security instead of anonymous.  When browsing the site from my laptop, I was able to access it with no iss…
Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
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.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now