R D <mrk279@yahoo.com> writes:
> i'm storing col1 to col3 as integers to save storage
> space(infact they are fixed point).I have many tables
> ctrated using this template only the view devidor
> constants are different for each table. Here they are
> 1000.0 1000.0 and 100.0 but for every table they are
> different. I would like to be able to execute the
> queryes like this using the index:
This table design is sufficiently ugly and pointless that I feel no deep
remorse over the fact that you can't use an index that way ;-)
Why are you bothering with these divisors? float4 is no larger than
int4 and will eliminate all of these pushups: just store the values
naturally.
If there really is some good reason to use scaled integers, you should
build yourself a scaled-integer datatype.
regards, tom lane