Обсуждение: Bug #830: 7.3 - timespan missing?

Поиск
Список
Период
Сортировка

Bug #830: 7.3 - timespan missing?

От
pgsql-bugs@postgresql.org
Дата:
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?

От
Tom Lane
Дата:
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?

От
Tom Lane
Дата:
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