On Fri, Apr 22, 2005 at 11:30:02AM +0200, Jerome Alet wrote: > On Fri, Apr 22, 2005 at 11:21:26AM +0200, Christoph Haller wrote: > > > > select '2005/04/22'::text::timestamp ; > > timestamp > > --------------------- > > 2005-04-22 00:00:00 > > (1 row) > > > > works for me. > > It works fine !!! > > Thanks so much for your help. > > I missed the '::text' intermediate conversion it seems
This is fixed in 8.0 (in 8.0.2, anyway). Casts from varchar no longer need an intermediate cast to text. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
