Greetings, I have a little problem here and need some help. I created a table where indexes are not working very well here. Please take a look at the code below (it's easier). Two databases with same problem : 7.0.2 and 7.0.3 both on linux redhat 6.2. Am I doing something wrong? bxs=# bxs=# CREATE TABLE hora_minuto( bxs(# hora char(5), bxs(# hora_minuto TIME, bxs(# CONSTRAINT XPKhora_minuto PRIMARY KEY (hora, hora_minuto) bxs(# ) bxs-# ; NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'xpkhora_minuto' for table 'hora_minuto' CREATE bxs=# bxs=# bxs=# \d hora_minuto Table "hora_minuto" Attribute | Type | Modifier -------------+---------+---------- hora | char(5) | not null hora_minuto | time | not null Index: xpkhora_minuto bxs=# bxs-# bxs-# bxs-# bxs-# bxs-# INSERT INTO hora_minuto VALUES( '', '13:38:00'); ERROR: parser: parse error at or near "]" bxs=# INSERT INTO hora_minuto VALUES( '', '13:39:00'); INSERT 2675143 1 bxs=# INSERT INTO hora_minuto VALUES( '', '13:40:00'); INSERT 2675144 1 bxs=# INSERT INTO hora_minuto VALUES( '', '13:41:00'); INSERT 2675145 1 bxs=# INSERT INTO hora_minuto VALUES( '', '13:42:00'); INSERT 2675146 1 bxs=# INSERT INTO hora_minuto VALUES( '', '13:43:00'); INSERT 2675147 1 bxs=# INSERT INTO hora_minuto VALUES( '', '13:44:00'); INSERT 2675148 1 bxs=# INSERT INTO hora_minuto VALUES( '', '13:45:00'); INSERT 2675149 1 bxs=# INSERT INTO hora_minuto VALUES( '', '13:46:00'); INSERT 2675150 1 bxs=# bxs=# bxs=# bxs=# bxs=# bxs=# bxs=# EXPLAIN SELECT hora_minuto FROM hora_minuto WHERE hora_minuto > '13:43:00'; NOTICE: QUERY PLAN: Seq Scan on hora_minuto (cost=0.00..22.50 rows=333 width=8) EXPLAIN bxs=# bxs=# bxs=# Regards, José Vilson de Mello de Farias Dígitro Tecnologia Ltda. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly