Hello 2009/8/4 Gert <gert.conra...@gmail.com>: > I'm a bit in the dark: > I use Windows XP > I use pgAdmin ver 1.8.4 > I use PostGres 8.3.6 >
You have to upgrade to 8.4. Default parameter's values are implemented in 8.4. regards Pavel Stehule > All the documentation points out that it is allowed to assign default > values to parameters, but I get a syntax error here. > > I would appreciate feedback. > > CREATE OR REPLACE FUNCTION myfunc(a integer , b integer DEFAULT 100) > RETURNS INTEGER AS $$ > select 200; > $$ language sql; > > ERROR: syntax error at or near "DEFAULT" > LINE 1: ...TE OR REPLACE FUNCTION ___myfunc(a int, b integer DEFAULT > 10... > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
