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

2009-08-04 Thread Gert
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

[GENERAL] Error when assigning default value for function parameter

2009-08-04 Thread 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 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