El Lun 20 Oct 2003 10:54, escribió:
> Martin Marques <martin@bugs.unl.edu.ar> writes:
> > OK, let me be more specific. I tried this aready with this error:
> >
> > 2003-10-20 09:28:05 [27039] ERROR: parser: parse error at or near ")"
> > at character 15
> > 2003-10-20 09:28:05 [27039] WARNING: plpgsql: ERROR during compile of
> > objetosdatosactualizadicc near line 2
>
> Line 2 of the function is not where your assignment is; there seems to
> be something wrong with your first variable declaration. I'm not sure
> what --- when I copied-and-pasted the text it worked fine. One
> possibility is that you seem to have tabs rather than spaces between
> the variable name and datatype --- if you are trying to feed this file
> in via psql, that could possibly boomerang on you.
Great! I don't understand why I started putting tabs. The first 4 functions
have spaces between the variable name and the type.
That made it pass. I am now working on another function which is called from
this one.
Is there a standard way of debugging plpgsql code?
--
11:11:01 up 17 days, 20:43, 3 users, load average: 1.54, 1.68, 1.29
-----------------------------------------------------------------
Martín Marqués | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------