Hi folks,
there's often some talk about indices cannot be used if datatypes
dont match.
On a larger (and long time growed) application I tend to use OID
for references on new tables while old stuff is using integer.
Is the planner smart enough to see both as compatible datatype
or is manual
On Fri, Apr 29, 2005 at 04:35:13AM +0200, Enrico Weigelt wrote:
there's often some talk about indices cannot be used if datatypes
dont match.
PostgreSQL 8.0 is smarter than previous versions in this respect.
It'll use an index if possible even when the types don't match.
On a larger (and