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])

Reply via email to