Re: plpgsql

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
-----------------------------------------------------------------