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-07 14:22:30
Message-ID: 20081107142230.GB11500@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 06, 2008 at 12:08:57AM +0200, Andrus wrote:
> >PG 8.3 would
> >even throw it out, unless dokumnr was explicitly cast to a float8 as
> >well.
>
> I tried in 8.3
>
> create temp table dok ( dokumnr serial primary key );
> select * from dok where dokumnr='1'::float8
>
> and this run without error.

Hum, it doesn't seem to does it. Sorry, I was thinking PG was more
strict than it appears to be.

> So i do'nt understand how 8.3 throws out.

It won't, I was getting confused!

Sam

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2008-11-07 14:23:15 Re: UPDATE tuples with a sub-select
Previous Message paulo matadr 2008-11-07 14:10:15 sum timestamp result in hours