Re: age / timestamp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chr(dot) Rossmanith" <cr(at)neuro(dot)ma(dot)uni-heidelberg(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: age / timestamp
Date: 2003-03-21 14:44:57
Message-ID: 12420.1048257897@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Chr. Rossmanith" <cr(at)neuro(dot)ma(dot)uni-heidelberg(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-03-21 14:56:37 Re: table sequence
Previous Message HK 2003-03-21 13:06:01 Initialising bit values inside stored procedure.