Re: 335 times faster (!) - Mailing list pgsql-general

From Jan Wieck
Subject Re: 335 times faster (!)
Date
Msg-id 3E3EED46.B4DBB952@Yahoo.com
Whole thread Raw
In response to Re: 335 times faster (!)  (Mikael Carneholm <carniz@spray.se>)
List pgsql-general
Mikael Carneholm wrote:
>
> > ------- Ursprungligt meddelande -------
> >
> > Från: Jan Wieck <JanWieck@Yahoo.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
anindex when two different data types are involved" - which makes it sound like this is a current-only drawback that
willbe 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@Yahoo.com #

pgsql-general by date:

Previous
From: "Steve Wolfe"
Date:
Subject: Re: Error: heap_mark4update: (am)invalid tid
Next
From: Tom Lane
Date:
Subject: Re: Error: heap_mark4update: (am)invalid tid