Bug #830: 7.3 - timespan missing?

Started by PostgreSQL Bugs Listover 23 years ago3 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
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 timespan in a few apps and my queries have been failing.

Sample Code

No file was uploaded with this report

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #830: 7.3 - timespan missing?

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

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #830: 7.3 - timespan missing?

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