Thread: Bug #830: 7.3 - timespan missing?

Bug #830: 7.3 - timespan missing?

From
pgsql-bugs@postgresql.org
Date:
Dustin Sallings (dustin+pgsqlbugs@spy.net) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
7.3 - timespan missing?

Long Description
I couldn't find any documentation on timespan other than saying it should be preferred over reltime, however I use
timespanin a few apps and my queries have been failing. 

Sample Code


No file was uploaded with this report

Re: Bug #830: 7.3 - timespan missing?

From
Tom Lane
Date:
pgsql-bugs@postgresql.org writes:
> 7.3 - timespan missing?

timespan's been deprecated since 7.0, and is now gone entirely.  Use
interval (which is what it was an alias for).

            regards, tom lane

Re: Bug #830: 7.3 - timespan missing?

From
Tom Lane
Date:
Dustin Sallings <dustin@spy.net> writes:
>     The ``reltime'' used to be a ``timespan.''  Is there a better way
> to construct this type of query?

'reltime' is deprecated in favor of 'interval', too.

            regards, tom lane