2013/8/26 Florian Weimer <fweimer(at)redhat(dot)com>
> On 08/26/2013 04:27 PM, Torello Querci wrote:
>
>> Create index statement that I use is:
>>
>> CREATE INDEX dati_impianto_id_tipo_dato_id_**data_misurazione_idx
>> ON dati
>> USING btree
>> (impianto_id , tipo_dato_id , data_misurazione DESC);
>>
>
> What are the data types of these columns?
>
>
impianto_id -> integer
tipo_dato_id -> integer
data_misurazione -> date
The index was present in the database before I drop it since one about year
and half.