Re: How to use index in WHERE int = float

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to use index in WHERE int = float
Date: 2008-11-05 21:07:51
Message-ID: 20081105210751.GW2459@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 05, 2008 at 08:52:50PM +0200, Andrus wrote:
> explain analyze select * from firma2.dok where dokumnr='1228137'::float8
>
> "Seq Scan on dok (cost=0.00..187766.23 rows=6255 width=1145) (actual
> time=43168.460..43176.063 rows=1 loops=1)"
> " Filter: ((dokumnr)::double precision = 1228137::double precision)"
> "Total runtime: 43176.375 ms"

I've just noticed that "actual time" doesn't run from zero; is this part
of another query, or is something else going on?

Sam

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Fernandez 2008-11-05 21:08:08 Upgrading Postgres version
Previous Message Greg Smith 2008-11-05 21:04:44 Re: Debugging infrequent pegged out CPU usage