Re: Select in function?

Thanks all, it's working great now.

Cheers. :-)

andrew(at)modulus(dot)org wrote:

> As per the documentation at:
> http://postgresql.planetmirror.com/users-lounge/docs/7.0/user/c40874113.htm#AEN4207
>
> When using SELECT in a PL/PGSQL function, you must either SELECT .. INTO or
> use the PERFORM query if you don't care about the return value from a
> SELECT. If you wish to use the special FOUND variable, you have to SELECT
> .. INTO.
>
> Hope that helps,
>
> Andrew.
>
> On Tue, 6 Feb 2001, Alfonso Peniche wrote:
>
> > I have the following function:
> >
> > CREATE FUNCTION RegistrarDesconexion( integer )
> > RETURNS integer
> > AS '
> > BEGIN
> > UPDATE BitacoraConexion
> > SET Desconexion = CURRENT_TIMESTAMP
> > WHERE IdBitacoraConexion = $1;
> > SELECT Desconexion FROM BitacoraConexion
> > WHERE IdBitacoraConexion = $1;
> > IF FOUND THEN
> > RETURN 1;
> > ELSE
> > RETURN 0;
> > END IF;
> > END;'
> > LANGUAGE 'plpgsql';
> >
> > and if I run:
> > select registrardesconexion (5);
> >
> > I get the following error:
> > ERROR: unexpected SELECT query in exec_stmt_execsql()
> >
> > I don't know what's wrong, though I assume it's saying I'm not allowed
> > to use the select statement where it is.