default parameters

Started by Robert Haasabout 16 years ago2 messageshackers
Jump to latest
#1Robert Haas
robertmhaas@gmail.com

According to http://www.postgresql.org/docs/current/interactive/plpgsql-porting.html
there are no default parameters in PostgreSQL, but according to
http://www.postgresql.org/docs/current/interactive/sql-createfunction.html
there are.

It looks like this was fixed in CVS HEAD at some point (maybe when the
changes regarding the scoping of column names vs. parameters were put
in) but I think we should back-patch the part that also applies to 8.4
so that the docs are internally consistent.

...Robert

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Robert Haas (#1)
Re: default parameters

Robert Haas <robertmhaas@gmail.com> writes:

According to http://www.postgresql.org/docs/current/interactive/plpgsql-porting.html
there are no default parameters in PostgreSQL, but according to
http://www.postgresql.org/docs/current/interactive/sql-createfunction.html
there are.

It looks like this was fixed in CVS HEAD at some point (maybe when the
changes regarding the scoping of column names vs. parameters were put
in) but I think we should back-patch the part that also applies to 8.4
so that the docs are internally consistent.

Yeah, go for it. I think I took those statements out in HEAD but forgot
about back-patching the correction.

regards, tom lane