Re: sintax??? - Mailing list pgsql-general

From Alfonso Peniche
Subject Re: sintax???
Date
Msg-id 3A7ACEE7.EE17BF59@iteso.mx
Whole thread Raw
In response to Re: sintax???  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Re: sintax???
List pgsql-general
Thanks, I just figured that out. 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'');


pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: Foreign Keys
Next
From: Fernando Schapachnik
Date:
Subject: Weird behavior