Bug #947: time(timenow()) Parse Error - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #947: time(timenow()) Parse Error
Date
Msg-id 20030417004534.647DC475B99@postgresql.org
Whole thread Raw
Responses Re: Bug #947: time(timenow()) Parse Error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Aaron Silver (silvera@ngt-dev.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
viaa 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #946: Problem to make version 7.3.2 with cygwin
Next
From:
Date:
Subject: Re: [BUGS] Psql 'Expanded display (\x)' behaviour