From: | R D <mrk279(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Indexes and Views |
Date: | 2001-02-24 11:22:53 |
Message-ID: | 20010224112253.1319.qmail@web10012.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi PostgreSQL folks,
I would like to know is there any way to use indexes
with the views or rules in this situation:
cteate table test1(col1 int,col2 int,col3 int);
insert into test1 .....;
..............
insert into test1 .....;
create index test1_col1_col2 on test1(col1,col2);
create view test1_view as
select col1/1000.0,
col2/1000.0,
col3/10.0
from test1;
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:
select * from test1_view
where col1=const1 and col2=const2;
select * from test2_view
where col1=const1 and col2=const2;
and etc.
not like this
select * from test1_view
where test1.col1=const1*1000
and test1.col2=const2*1000;
select * from test2_view
where test2.col1=const1*col1_dividor
and test2.col2=const2*col2_dividor;
I do not want the user application to know and to deal
with this table specific constant dividors.
So can I create some rules to be able to do this?
Is it possible to use index in this situation at all?
Is there any other way to get the same results?
I cheked the docs but could not find any solution.
Sorry for the long and badly formuled introduction !
Hopeing you will help me!
best regards,
Rumen
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-02-24 16:35:55 | Re: Indexes and Views |
Previous Message | Peter Eisentraut | 2001-02-24 11:21:56 | Re: lock the database |