How to store currency ranges in a Postgres table?

Question

I am using Postgres 9.3.

I have to store range data like <250ドルK, 250ドルK-4ドルM, etc which we will display in a dropdown.

now I am making a table for all possible options that can be configured from an admin interface.

Should I take separate column for min,max,currency_type(dollar,euro) and a column to store K,M etc or there is a better way to do that ?

• CodeART: Three columns: Start, End, CurrencyType. E.g. 0, 250, USD
• MetaFight: just a suggestion: do not store K or M (order of magnitude) in the database. This is considered display/formatting logic and can be calculated on the fly. I'd even go as far as saying it should be calculated on the fly because it is a more flexible approach.
• pdr: @MetaFight: More importantly, you can't compare 5K to 4M. But you can compare 5000 and 4000000. So you can't do things like finding the overlaps in ranges. Of course, if you're not going to do all of that, you might as easily store the range as a display string.
• Amogh Talpallikar: I am using postgres datatype range. that should be fine right ?
• Robert Harvey: What relevance does the range data type have here?

Answer 1

Guessing you will be needing ranges for different kinds of dropdowns;

enter image description here

Answer 2

If these are intended to be all-encompassing ranges that all values must fall within, I'd just store either the maximum or minimum value of the range in a single column.

ID | Amount 
-----------
 1 | 0
 2 | 250000 
 3 | 500000 
 4 |1000000 
 5 |2000000

You can calculate the actual ranges on the fly from this.