Search Postgresql Archives

Default Cast type

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux