Howdy all,

The PostgreSQL documentation says of the INTERVAL type:

Internally interval values are stored as months, days, and
seconds.
<URL:http://www.postgresql.org/docs/8.1/static/datatype-datetime.html#AEN4775>

I'm looking for a way to get the *total* number of months contained in
an interval value. E.g., I want something that provides the following
results:

interval '3 months' => 3
interval '1 year' => 12
interval '1 year 5 months' => 17
interval '2 years 4 months' => 28

Unfortunately, although PostgreSQL internally knows the total number
of months in an interval value, I can't find in the documentation a
way to get at that value. I suppose I could perform an explicit
calculation of years-times-12, but this seems needless overhead for a
query when the quantity I need is already stored directly in the
value.

Please show me how, within SQL, I can get at the
total-number-of-months quantity that the documentation says is stored
for an interval value.

--
\ "I took a course in speed waiting. Now I can wait an hour in |
`\ only ten minutes." -- Steven Wright |
_o__) |
Ben Finney

begin Ben Finney schrieb:
test=*# select extract (years from interval '2 years 4 months') * 12 + extract(month from interval '2 years 4 months');
?column?
----------
28
(1 row)




end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net