Bruce Momjian <[email protected]> writes:
> Oh, one more thing. With the new patch I just posted, '0 hours' and
> 'HH' returns 12:
> test=> select to_char('0 hours'::interval, 'HH');
> to_char
> ---------
> 12
> (1 row)
Yeah, it's done that in every release since 7.2. 8.1.0 is the only
release that thinks 00 is correct.
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
