On 12/3/21 08:12, Sebastien Flaesch wrote:
Hum....
test1=> create table tab2 ( i interval hour to minute );
CREATE TABLE
test1=> insert into tab2 values ( interval '9999-10 555 11:22:33' );
INSERT 0 1
test1=> select * from tab2;
i
--------------------------------------
9999 years 10 mons 555 days 11:22:00
(1 row)
Expected?
Qualifiers "hour to minute" seem just to be some decoration...
https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-INTERVAL-INPUT
"... Also, field values “to the right” of the least significant field
allowed by the fields specification are silently discarded. For example,
writing INTERVAL '1 day 2:03:04' HOUR TO MINUTE results in dropping the
seconds field, but not the day field."
Seb
------------------------------------------------------------------------
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
