Re: Bug #580: Optimizer uses seq scan only

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: j(dot)richter(at)wallstreet-develop(dot)de, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #580: Optimizer uses seq scan only
Date: 2002-02-11 23:21:56
Message-ID: 17834.1013469716@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> CREATE TABLE test (
> testid int8 not null default 0,

> janko=# EXPLAIN SELECT * FROM test WHERE testid = 12345;

Try 12345::int8. Yes, we know it's a pain in the neck.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2002-02-11 23:43:23 Re: Bug #580: Optimizer uses seq scan only
Previous Message pgsql-bugs 2002-02-11 22:51:35 Bug #580: Optimizer uses seq scan only