Re: Indexes not working, please help.

From: Ricardo Junior <suga(at)netbsd(dot)com(dot)br>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Indexes not working, please help.
Date: 2002-07-05 04:39:45
Message-ID: Pine.LNX.4.44.0207050137190.1388-100000@ricardo.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


---
Index Scan using medidas_pkey on medidas (cost=0.00..3.01 rows=1
width=36)
---

Indeed, it got a bit faster... :D

Thanks!

[]'s
Ricardo.

On Fri, 5 Jul 2002, Tom Lane wrote:

> Ricardo Ryoiti Sugawara Junior <suga(at)netbsd(dot)com(dot)br> writes:
> > cod | bigint | not null default
>
> > explain select * from medidas where cod = 1231232;
>
> Try "1231232::bigint".
>
> regards, tom lane
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Antonis Antoniou 2002-07-05 06:58:27 Re: Indexes not working, please help.
Previous Message Tom Lane 2002-07-05 04:34:12 Re: Indexes not working, please help.