Re: Wrong parameter names for make_interval (Postgres 13)
От | Pavel Stehule |
---|---|
Тема | Re: Wrong parameter names for make_interval (Postgres 13) |
Дата | |
Msg-id | CAFj8pRBXRGRTz-hVtQfmkqCGAh9R3THhmuVsg9B4ZRfjyau3dw@mail.gmail.com обсуждение исходный текст |
Ответ на | Wrong parameter names for make_interval (Postgres 13) (Thomas Kellerer <shammat@gmx.net>) |
Ответы |
Re: Wrong parameter names for make_interval (Postgres 13)
|
Список | 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 по дате отправления: