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

Bug #947: time(timenow()) Parse Error

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #947: time(timenow()) Parse Error
Date: 2003-04-17 00:45:34
Message-ID: 20030417004534.647DC475B99@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Aaron Silver (silvera(at)ngt-dev(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
time(timenow()) Parse Error

Long Description
In using Postgres 7.2.2 on a client's system I received a parse error using time(timenow()). Either in a function or via a command-line "select time(timenow());" statement, I received a "parse error near timenow". A "select date(timenow());" worked fine. Doing "select time('2003-04-15 00:00:00');" worked fine also.

This was not an issue on a machine running Postgres 7.1.3.

Is/was this a known issue? Is there a patch, or in what release was this fixed?

Aaron 

Sample Code


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2003-04-17 03:28:46
Subject: Re: Bug #947: time(timenow()) Parse Error
Previous:From: Tom LaneDate: 2003-04-16 19:50:00
Subject: Re: Bug #946: Problem to make version 7.3.2 with cygwin

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