Обсуждение: 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!