On Fri, 27 Jun 2003, Holger Marzen wrote: > In 7.1.3 I can use > > select timestamp(date '2001-01-01', time '00:00'); > > but in 7.2.4 I get > > db1=# select timestamp(date '2001-01-01', time '00:00'); > ERROR: parser: parse error at or near "date"
To be closer to the standard, timestamp() became a reference to the datatype with a given precision (given in the parens). You can still get at the functions with "timestamp"(...), but I think you can also use date '2001-01-01' + time '00:00' as well. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
