Thread: Error when assigning default value for function parameter
I'm a bit in the dark: I use Windows XP I use pgAdmin ver 1.8.4 I use PostGres 8.3.6 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...
Hello 2009/8/4 Gert <gert.conradie@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 >
You can't use default values in a function, that option is available as of version 8.4. You are using 8.3. Regards, Frank Op 4 aug 2009, om 19:16 heeft Gert het volgende geschreven: > I'm a bit in the dark: > I use Windows XP > I use pgAdmin ver 1.8.4 > I use PostGres 8.3.6 > > 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 Frank Heikens frankheikens@mac.com
Thanks Pavel & Frank. Installed version 8.4, work perfect. Apologies. I did check ver 8.3 documentation earlier as well, but can confirm that I clearly read what I wanted to hear, and not what was actually there. Thanks again!