Re: [GENERAL] Default Cast type

2007-03-07 Thread Tom Lane
Markus Schulz <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 4: Ha

[GENERAL] Default Cast type

2007-03-07 Thread Markus Schulz
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 ...