Re: Problem creating index

[Torello Querci <tquerci@xxxxxxxxx>]

2013/8/26 Florian Weimer <fweimer@xxxxxxxxxx>

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.