Re: Re: sintax???

It looks like you also may have some dos style end of lines in whatever
you entered in.  Did you cut and paste or copy a file from a windows
box?

That's why the " is over the E in ERROR because it's seeing the
CR character.

On Fri, 2 Feb 2001, Alfonso Peniche wrote:

> Thanks, Now I have another problem:
>
> If I run select registrarconexion('mine', '201.201.201.1','MYCPU');
>
> I get a message
>
> NOTICE:  plpgsql: ERROR during compile of registrarconexion near line 1
> "RROR:  parse error at or near "
>
> Any ideas?
>
> Thanx.
>
> Stephan Szabo wrote:
>
> > On Thu, 1 Feb 2001, Alfonso Peniche wrote:
> >
> > > I have the following:
> > >
> > > CREATE FUNCTION RegistrarConexion(char(8),char(16),char(20))
> > > RETURNS integer
> > > AS '
> > >         DECLARE ret integer;
> > >
> > >         BEGIN
> > >                 INSERT INTO BitacoraConexion(username, IPmaquina,
> > > nombremaquina, conexion)
> > >                 VALUES ($1, $2, $3, CURRENT_TIMESTAMP);
> > >
> > >                 SELECT INTO ret
> > > currval('bitacoraconex_idbitacoracon_seq');
> > >
> > >                 RETURN ret;
> > >         END;'
> > > LANGUAGE 'plpgsql';
> > >
> > > and if I execute this file I get the following error:
> > >
> > > psql:SPRegConex.sql:20: ERROR:  parser: parse error at or near
> > > "bitacoraconex_idbitacoracon_seq"
> > >
> > > I asume it's due to a sintax error having to do with "currval", but I
> > > can't find what the proper sintax would be for 'plpgsql' for getting the
> > > last sequence value assigned (I even tried
> >
> > I believe the problem is that you need to escape the single quotes,
> > otherwise it thinks you're ending the function text.  Try
> > currval(''bitacoraconex_idbitacoracon_seq'');
>