Re: Query planner isn't using my indices - Mailing list pgsql-general

On Tue, 8 Jan 2002, Alaric B. Snell wrote:

> frontwire=# \d stakeholder_pk
> Index "stakeholder_pk"
>  Attribute |  Type
> -----------+--------
>  id        | bigint
> unique btree
>
> frontwire=# explain select * from stakeholder where id = 1;
> NOTICE:  QUERY PLAN:
>
> Seq Scan on stakeholder  (cost=0.00..602.81 rows=1 width=336)
>

See past discussions, you'll need to either explicitly cast the
constant to bigint or quote it, because otherwise it prematurely
casts the constant into an int4.