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
pgsql-general by date
|Next:||From: Roderick A. Anderson||Date: 2003-06-26 23:59:47|
|Subject: Re: 7.3.3 RPM build|
|Previous:||From: Ian Barwick||Date: 2003-06-26 23:04:07|
|Subject: Re: timestamp() broken in 7.2.4?|