Pavel Stehule wrote:
xsd knows datetime type. You can inherit it, and then you have to
respect it. You can do own type, but you lost information, and any
general scripts don't understand. I don't know why xsd doesn't iso
format, but its simply fact. Please read this discussion:
http://forums.oracle.com/forums/thread.jspa?threadID=467278&tstart=0
Ok, I've re-read the patch, and now understand what it's doing. Sorry
for the noise.
cheers
andrew
---------------------------(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
