Re: Wrong parameter names for make_interval (Postgres 13)

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
>
>
>