Re: Wrong parameter names for make_interval (Postgres 13) - Mailing list pgsql-docs

From Pavel Stehule
Subject Re: Wrong parameter names for make_interval (Postgres 13)
Date
Msg-id CAFj8pRBXRGRTz-hVtQfmkqCGAh9R3THhmuVsg9B4ZRfjyau3dw@mail.gmail.com
Whole thread Raw
In response to Wrong parameter names for make_interval (Postgres 13)  (Thomas Kellerer <shammat@gmx.net>)
Responses Re: Wrong parameter names for make_interval (Postgres 13)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-docs


po 5. 10. 2020 v 15:56 odesílatel Thomas Kellerer <shammat@gmx.net> napsal:
There is a typo in the parameter names of the make_interval() function.

The parameter names are all defined with plural, not singular as it is shown
in the Postgres 13 manual.

So instead of

    make_interval ( [ year int [, month int [, week int [, day int [, hour int [, min int [, sec double precision ]]]]]]] )

it should be

    make_interval ( [ years int [, months int [, weeks int [, days int [,hours int [, mins int [, secs double precision ]]]]]]] )

this syntax is not correct too

It should be

    make_interval( years int default 0, month int default 0, days int default 0, hours int default 0, secs double precision default 0)

Regards

Pavel



Thomas


pgsql-docs by date:

Previous
From: Thomas Kellerer
Date:
Subject: Wrong parameter names for make_interval (Postgres 13)
Next
From: Tom Lane
Date:
Subject: Re: Wrong parameter names for make_interval (Postgres 13)