Unpredictable text -> date implicit casting behaviour/to_date bug

The implicit casting of text to date is normally quite good, however i think it should only use one method during a given query (or maybe transaction?) or maybe it should give a notice of some sort? - i was quite astonished when I discovered the following: (look closely at row 4 and 5 vs the others)

SELECT ordredato, ordredato::date from old_faktura where status = 'ORD';
ordredato | ?column?
-----------+------------
18.10.01 | 2001-10-18
31.10.01 | 2001-10-31
01.11.01 | 2001-01-11
03.11.01 | 2001-03-11
03.11.01 | 2001-03-11
10.11.01 | 2001-10-11
26.11.01 | 2001-11-26

Added to the fact that to_date has a bug:

SELECT ordredato, ordredato::date, to_date(ordredato, 'DD.MM.YY') from old_faktura where status = 'ANN';
ordredato | ?column? | to_date
-----------+------------+---------------
18.04.00 | 2000-04-18 | 0001-04-18 BC
30.08.01 | 2001-08-30 | 2001-08-30
18.04.00 | 2000-04-18 | 0001-04-18 BC

It sometimes makes converting dates a little challenge...

Aasmund Midttun Godal

aasmund(at)godal(dot)com - http://www.godal.com/
+47 40 45 20 46