Postgres Pro
Downloads
Home   >   mailing lists

Re: age / timestamp - Mailing list pgsql-novice

From Tom Lane
Subject Re: age / timestamp
Date
Msg-id 12420.1048257897@sss.pgh.pa.us
Whole thread Raw
In response to age / timestamp  ("Chr. Rossmanith" <cr@neuro.ma.uni-heidelberg.de>)
List pgsql-novice
Tree view 
"Chr. Rossmanith" <cr@neuro.ma.uni-heidelberg.de> writes:
> I can create this view in the 7.1.3 system sucessfully but if I try a
> select I get the error message:

> ERROR:  Unable to decode timestamp

Can't say anything much without seeing the input values that make the
age() function fail that way.  (It is the age() --- AFAICS no other
function in the system uses exactly that phrase.)

            regards, tom lane

pgsql-novice by date:

Previous
From: HK
Date:
Subject: Initialising bit values inside stored procedure.
Next
From: Tom Lane
Date:
Subject: Re: table sequence