Re: How to use index in WHERE int = float

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to use index in WHERE int = float
Date: 2008-11-05 22:08:57
Message-ID: get5hp$1o7e$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2008-11-05 22:20:34 Re: How to use index in WHERE int = float
Previous Message Andrus 2008-11-05 21:49:52 Re: How to use index in WHERE int = float