Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group