Re: Sequential Scan Index Bug

Presumably, but that is not what I was doing.

I was taking a number from a user, which was supposed to be divisible by an
integer. Sometimes the user left off the last digit when typing in the
number or otherwise typed it in wrong, rendering the input not divisible by
that number.

So it was looking for something like 4.345.

Gabriel

_________________
Gabriel Weinberg
yegg(at)alum(dot)mit(dot)edu

-----Original Message-----
From: Stephan Szabo [mailto:sszabo(at)megazone(dot)bigpanda(dot)com]
Sent: Wednesday, April 07, 2004 11:35 AM
To: Gabriel Weinberg
Cc: 'Bruno Wolff III'; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] Sequential Scan Index Bug

On Wed, 7 Apr 2004, Gabriel Weinberg wrote:

> Yes, I thought I had done that, but now that I figured out what was
> going on, I did it for all cases. So it is no longer occurring for
> me, but it still seems like a bug in PostgreSQL. I would expect it to
> throw an error immediately, instead of scanning the table for a value
> of a different type.

But what if you said id = 4.0? Would you want it to find the id=4 row?