Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group