Home > mailing lists

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

From	adb
Subject	index used when casting to different type?
Date	February 19, 2001 21:34:40
Msg-id	Pine.GSO.4.10.10102191830030.2561-100000@hairdini.beast.com Whole thread Raw
Responses	Re: index used when casting to different type? Re: index used when casting to different type?
List	pgsql-general

Tree view

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.

pgsql-general by date:

From: Stephan Szabo
Date: 19 February 2001, 21:26:51
Subject: Re: Weird indices

From: Larry Rosenman
Date: 19 February 2001, 21:34:54
Subject: Re: Re: Postgres slowdown on large table joins

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

Previous

Next