| From: | Mikael Carneholm <carniz(at)spray(dot)se> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | JanWieck(at)Yahoo(dot)com |
| Subject: | Re: 335 times faster (!) |
| Date: | 2003-02-03 21:27:01 |
| Message-ID: | 1044307621016697@lycos-europe.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> ------- 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?
- 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Reyes | 2003-02-03 21:32:10 | Dealing with complex queries |
| Previous Message | Jan Wieck | 2003-02-03 21:11:53 | Re: 335 times faster (!) |