FAQ

On Thu, 26 Jun 2003, Stephan Szabo wrote:
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.
Ah, I see. My condition

where interface = 'ppp0' and
age(current_timestamp, date + time) < '1 hour'

works now. I can simply add the columns date and time. Cool.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJun 27, '03 at 5:40a
activeJun 27, '03 at 5:40a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Holger Marzen: 1 post

People

Translate

site design / logo © 2021 Grokbase