Thread: defaults in a function
Hi, In python when I create a method/function is set a default value for a passed value if one is not provided. def foo(self, event = None): In the above function if the second value is not passed a value of None is used as the default. Is this possible with plpgsql??? Johnf
On Jun 6, 2012, at 11:08, John Fabiani <johnf@jfcomputer.com> wrote: > Hi, > In python when I create a method/function is set a default value for a passed value if one is not provided. > > def foo(self, event = None): > > In the above function if the second value is not passed a value of None is used as the default. > > Is this possible with plpgsql??? > > Johnf > http://www.postgresql.org/docs/9.0/interactive/sql-createfunction.html ... param_n type DEFAULT value OR ... param_n type = value It is SQL DDL syntax and not specific to the language the function is written in. David J.