Select in function?
От | Alfonso Peniche |
---|---|
Тема | Select in function? |
Дата | |
Msg-id | 3A8097CB.D578BA8E@iteso.mx обсуждение исходный текст |
Ответы |
Re: Select in function?
Re: Select in function? |
Список | 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 по дате отправления: