Default Cast type - Mailing list pgsql-general

From Markus Schulz
Subject Default Cast type
Date
Msg-id 200703071435.14979.msc@antzsystem.de
Whole thread Raw
Responses Re: Default Cast type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Markus Schulz
Date:
Subject: Re: pg_dump and restore problem with function as DEFAULT-Constraint
Next
From: Tom Lane
Date:
Subject: Re: postgres slower on nested queries