On Friday 27 June 2003 00:47, 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"
changed in 7.2, see: http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=release-7-2.html "The timestamp(), time(), and interval() functions are no longer available. Instead of timestamp(), use timestamp 'string' or CAST. " -> something like: select timestamp '2001-01-01 00:00'; should work Ian Barwick [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])