> Hi Bruce,
>
> Ok. Sorry about the delay.
>
> I added the math.h but that doesn't seem to change the
> query plan output.
>
> I then dropped all the indices, made a new one on three of the
> variables and clustered:
>
> create index m_col on lmctot using btree (j_m, h_m, k_m);
> cluster m_co
Bruce Momjian wrote on Wed, 07 Jul 1999 12:29:13 EDT
>> Thanks, Bruce!
>>
>> Yes, I tried the latter query and it's the same:
>>
>> --
>>
>> lmc=> explain select count(*) from lmctot where j_m>3.4::float4 and j_m<3.5:
>:float4;
>> NOTICE: QUERY P
> Thanks, Bruce!
>
> Yes, I tried the latter query and it's the same:
>
> --
>
> lmc=> explain select count(*) from lmctot where j_m>3.4::float4 and j_m<3.5::float4;
> NOTICE: QUERY PLAN:
>
> Aggregate (cost=62349.97 rows=788100 width=4)
> ->
hello all
i want to : update virtual_table set field1 = 3 where index = 4;
create table virtual_table(index int4, field1 int4);
create table table1 ( )inherits(virtual_table);
create table table2( )inherits(virtual_table);
insert into table1(index, field1) values(4, 0);
and i want to
Bruce Momjian wrote on Wed, 07 Jul 1999 04:07:00 EDT
>> lmc=> explain select count(*) from lmctot where j_m>'3.4' and j_m<'3.5';
>> NOTICE: QUERY PLAN:
>>
>> Aggregate (cost=62349.97 rows=788100 width=4)
>> -> Index Scan using j on lmctot (cost=62349.97 rows=788100 width=4)
>>
>>
>Please
> lmc=> explain select count(*) from lmctot where j_m>'3.4' and j_m<'3.5';
> NOTICE: QUERY PLAN:
>
> Aggregate (cost=62349.97 rows=788100 width=4)
> -> Index Scan using j on lmctot (cost=62349.97 rows=788100 width=4)
>
>
Please try this:
lmc=> explain select count(*) from lmctot where j
