Select in function? - Mailing list pgsql-general

From Alfonso Peniche
Subject Select in function?
Date
Msg-id 3A8097CB.D578BA8E@iteso.mx
Whole thread Raw
Responses Re: Select in function?
Re: Select in function?
List pgsql-general
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.


pgsql-general by date:

Previous
From: Warren Vanichuk
Date:
Subject: Deadlock and aborted queries..
Next
From: Tom Lane
Date:
Subject: Re: pg_dump crash