--- Tom Lane <[EMAIL PROTECTED]> wrote:
> R D <[EMAIL PROTECTED]> 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 t
R D <[EMAIL PROTECTED]> 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 t
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 t
