Quick Links

index used when casting to different type?

From:	adb <adb(at)Beast(dot)COM>
To:	pgsql-general(at)postgresql(dot)org
Subject:	index used when casting to different type?
Date:	2001-02-20 02:32:20
Message-ID:	Pine.GSO.4.10.10102191830030.2561-100000@hairdini.beast.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

Thanks,

Alex.

Responses

Re: index used when casting to different type? at 2001-02-20 02:47:01 from Tom Lane
Re: index used when casting to different type? at 2001-02-20 02:53:32 from Larry Rosenman

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2001-02-20 02:34:34	Re: Weird indices
Previous Message	Stephan Szabo	2001-02-20 02:25:59	Re: Weird indices