Re: How to use index in WHERE int = float - Mailing list pgsql-general

From Sam Mason
Subject Re: How to use index in WHERE int = float
Date
Msg-id 20081107142230.GB11500@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Re: How to use index in WHERE int = float  ("Andrus" <kobruleht2@hot.ee>)
List 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

pgsql-general by date:

Previous
From: paulo matadr
Date:
Subject: sum timestamp result in hours
Next
From: Thomas Kellerer
Date:
Subject: Re: UPDATE tuples with a sub-select