Default Cast type

From: Markus Schulz <msc(at)antzsystem(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Default Cast type
Date: 2007-03-07 13:35:14
Message-ID: 200703071435.14979.msc@antzsystem.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Floyd Shackelford 2007-03-07 14:29:31 foreign key support for inheritance
Previous Message Markus Schulz 2007-03-07 13:31:11 Re: pg_dump and restore problem with function as DEFAULT-Constraint