Re: Select in function?

It wants you to do a
SELECT INTO <var> ...
in the function, something like

'DECLARE
rec RECORD
BEGIN
...
SELECT INTO rec Desconexion FROM BitacoraConexion
...
'

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.
>
> Any ideas or comments.
>
> Thanx.
>