Bruno Wolff III <[EMAIL PROTECTED]> writes: > Chris Hoover <[EMAIL PROTECTED]> wrote: >> I can get it to create on if I create a special function that just >> takes the field to be converted and returns the converted date.
> That is what you have to do in older versions of postgres. You don't have > to do that in 8.0 (I am not sure about 7.4). 7.4 does it too. 7.3 is ... um ... old. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match