On Mon, Jan 25, 2016 at 2:07 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:

> Corey Huinker <corey.huin...@gmail.com> writes:
> > Incidentally, is there a reason behind the tendency of internal functions
> > to avoid parameter defaults in favor of multiple pg_proc entries?
> Yes: you can't specify defaults in pg_proc.h.
> We work around that where absolutely necessary, see the last part of
> system_views.sql.  But it's messy enough, and bug-prone enough, to be
> better avoided --- for example, it's very easy for the redeclaration
> in system_view.sql to forget a STRICT or other similar marking.
> Personally I'd say that every one of the existing cases that simply has
> a default for the last argument was a bad idea, and would better have
> been done in the traditional way with two pg_proc.h entries.
>                         regards, tom lane

...which answers my follow up question where make_interval was getting the
defaults I saw in the table but not the .h file. Thanks!

Reply via email to