Antonis,
That was not the case, it appears that PostgreSQL have problems
matching the type on the table and on the queries. For instance, cod is a
bigserial primary key, so it does has a index but when you query it
without specifying ::bigint after the value, I don't know why, PostgreSQL
won't use it's indexes.
With the "serial" type it works perfectly.
Thanks anyway,
Ricardo.
On Fri, 5 Jul 2002, Antonis Antoniou wrote:
> Hi,
> Is your index on the attribute cod? If not then try this:
> CREATE INDEX teste ON medidas (cod);
>
> Thanks
> Antonis
