Thread: Default Cast type

Default Cast type

From
Markus Schulz
Date:
Hello,
how can i choose a default data type for casts?
PG 7.4 has some problems to use an existing index, if the datatype not
match.
For example i have a int8 primary id column and search for this column,
i can't use the index for queries like:
SELECT ... WHERE id = 12345
if i'm use:
SELECT ... WHERE id = 12345::int8
it will use the index.

Is there a solution for PG 7.4 to choose the default datatype for this
way of casting?


--
Markus Schulz

Re: Default Cast type

From
Tom Lane
Date:
Markus Schulz <msc@antzsystem.de> writes:
> Is there a solution for PG 7.4 to choose the default datatype for this
> way of casting?

Yeah, it's called "update to 8.x" ...

            regards, tom lane