Re: How to use index in WHERE int = float

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: How to use index in WHERE int = float
Дата
Msg-id 20081107142230.GB11500@frubble.xen.chris-lamb.co.uk
обсуждение исходный текст
Ответ на Re: How to use index in WHERE int = float  ("Andrus" <kobruleht2@hot.ee>)
Список 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 по дате отправления:

Предыдущее
От: paulo matadr
Дата:
Сообщение: sum timestamp result in hours
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: UPDATE tuples with a sub-select