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

> 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.

So i do'nt understand how 8.3 throws out.

Andrus.