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 (an
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 c
