Re: index used when casting to different type? - Mailing list pgsql-general

From Larry Rosenman
Subject Re: index used when casting to different type?
Date
Msg-id 20010219205332.A2503@lerami.lerctr.org
Whole thread Raw
In response to index used when casting to different type?  (adb <adb@Beast.COM>)
List pgsql-general
* adb <adb@Beast.COM> [010219 20:43]:
> If I have a table with a key column stored as text and
> another table with a key column stored as an int4 and
> I join the two by casting the in4 column to text, will the existing
> index on the int4 key be used?
I doubt it.
>
> Thanks,
>
> Alex.
>

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: index used when casting to different type?
Next
From: Joseph Shraibman
Date:
Subject: Re: Weird indices