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

From Mikael Carneholm
Subject Re: 335 times faster (!)
Date
Msg-id 1044307621016697@lycos-europe.com
Whole thread Raw
In response to 335 times faster (!)  (Mikael Carneholm <carniz@spray.se>)
List pgsql-general
> ------- 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? 

- Mikael

_____________________________________________________________
Här börjar internet!
Skaffa gratis e-mail och gratis internet på http://www.spray.se

Träffa folk från hela Sverige på ett och samma ställe - http://chat.spray.se/



pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: 335 times faster (!)
Next
From: Francisco Reyes
Date:
Subject: Dealing with complex queries