Re: timestamp() broken in 7.2.4?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Holger Marzen <holger(at)marzen(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: timestamp() broken in 7.2.4?
Date: 2003-06-26 23:12:15
Message-ID: 20030626161010.C56339-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roderick A. Anderson 2003-06-26 23:59:47 Re: 7.3.3 RPM build
Previous Message Ian Barwick 2003-06-26 23:04:07 Re: timestamp() broken in 7.2.4?