Skip site navigation (1) Skip section navigation (2)

Re: Sequential Scan Index Bug

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Gabriel Weinberg <yegg(at)alum(dot)mit(dot)edu>
Cc: 'Bruno Wolff III' <bruno(at)wolff(dot)to>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Sequential Scan Index Bug
Date: 2004-04-07 17:18:42
Message-ID: 20040407100825.J69637@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, 7 Apr 2004, Gabriel Weinberg wrote:

> I would expect if I did intcol = 4.35 or intcol = 'abc', it would throw a
> type mismatch error.

Well, in practice, the former is AFAICS required to do something "right"
by the SQL spec because it explicitly states that all all numbers are
mutually comparable, so erroring would technically be against spec.  It's
possible that we could do something more intelligent than the current
behavior for that case but I can't come up with a particularly good
choice that wouldn't have bad effects elsewhere.

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-04-07 18:47:53
Subject: Re: INSERT INTO ... SELECT
Previous:From: Gabriel WeinbergDate: 2004-04-07 17:03:21
Subject: Re: Sequential Scan Index Bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group