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