Re: [GENERAL] Error when assigning default value for function parameter

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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Error when assigning default value for function parameter

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 p

Re: [GENERAL] Error when assigning default value for function parameter

Hello 2009/8/4 Gert : > 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 > val

[GENERAL] 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 DEF