Re: 335 times faster (!)

Mikael Carneholm wrote:
>
> > ------- Ursprungligt meddelande -------
> >
> > Från: Jan Wieck <JanWieck(at)Yahoo(dot)com>
> > Datum: Mon, 03 Feb 2003 16:11:53 -0500
> >
> >It is the other way round. The backend converts a non-quoted sequence of
> >digits too early into an int4 and cannot recover from that "mistake".
> >
>
> Is this on the TODO list for 7.4? The current docs (http://developer.postgresql.org/docs/postgres/datatype.html#DATATYPE-INT) state that "PostgreSQL currently cannot use an index when two different data types are involved" - which makes it sound like this is a current-only drawback that will be fixed later on. T/F?

Exactly ... only I cannot define "later on" very precise. Assuming the
time-line going forward, it's in the future, somewhere.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #